New User ID not working in custom function with user_register hook

Because you need to give your function a parameter:

function auto_follow_admin( $user_id ) {

    // Now you can use $user_id, which is passed to the function from the hook caller

}