Regardless of how this box (Require Approval Before New Users Can Sign In?) is checked in the site settings>permissions the new users never show up on the waiting for approval list:
/MemberList.aspx?needapproval=true
I even went in the database (mp_users) and played with the fields for ProfileApproved, etc. True/False, regardless I can never get new registrants to appear on the need approval list. The email goes out and I can search and find the new user, it's just that they don't appear in the list (which is important, critical really for the feature when you have hundreds of users).
MP version: 2.3.8.5