There are quite a few good LFS in the metro area. Here is a listing of the ones I frequent.
Cichlid world - Garden City
Greenwoods - Livonia
101 aquariums - Taylor
Captive reef - Garden city
Pet Connection - Livonia
Pet Station - Taylor (I think its on telegraph and van born)
Something fishy (Westland)
Fantastic Fins - Plymouth (I think its on Ann Arbor rd.)
Choice Aquariums - West Bloomfield
yeah oceans and see's is a great store but they are really big into salt water, my dad used to get all his fish from there years ago and, but they do have a bunch of little freshwater stuff.