Nice idea. In the site approving the user's registration, method to turn ON approval flag of user who changed own profile is simple. However, the user needing re-approval can't post. This may be problem... ?
Reference:
qa-include/qa-app-users.php::QA_USER_FLAGS_MUST_APPROVE
qa-include/qa-db-users.php::qa_db_user_set_flag()