Welcome to the Motor City!
For apartments, check out:http://www.waldmanproperties.com/residential2.htm
Most of these are in Royal Oak and Ferndale, which are adjacent to each other and pretty much the gay district. Berkley is next door to Royal Oak and Farmington Hills is 15 minutes west of there.
I know one of the current apartment managers is gay and the office manager is gay friendly.
Not sure what constitutes "affordable", but I could probably get them to swing you a better deal than normal.
Also check out:www.TeamMichigan.USwww.MichiganPanthers.ORG