I know of a bunch in my area... here's my opinions...
Oceans and Seas - Roseville: Pretty good for fish
Pet Connection - Livonia: One of the best
The Fish Guy - West Bloomfield: New, not much stock but good prices and should get better
Choice Aquariums - Farmington Hills: Good but very overpriced on everything
***** - Novi: Not bad, good prices
The Fish Tank - Westland (I think): Great store, small but great
Aquatic Discoveries - Mound Rd. (Not sure what city): great for corals/inverts, cool display tanks, great place to shop for tanks, stands, etc.
Bad LFS...
The Aquarium - Livonia: they don't know much, will try to sell anything
Greenwoods - Garden City (I think): Poor conditions, no selection, no knowledge
These are the ones I know. Let me know if you know of others.