this should get you what you want per database (without excluding any users)

select name from sys.database_principals

where type in ('S','G','U')

give it a try with sp_msforeachdb and post back if you are still having issues.