I have my freshwater tanks in the basement. Been wanting to move an extra computer chair downstairs to have an excuse to just stare at the tanks instead of viewing only when feeding/maintenance.
I have a 38 gallon and 13 gallon SW tanks in the family room so I can watch them whenever I am in the room. I also have a 6 gallon with a betta and some chili rasbora and a slew of snails (won't stop breeding, lol)
I also have a 5.5 gal tank that holds feeder minnows for my SW venomous leaf fish-Chestnut. He's in the 13 gallon.