I think "amusingly tolerant" would best describe my wife's relationship with my tank. It's actually her favorite room to read or study in b/c it's pretty to look at and makes soothing water noises. She's generally interested in how all of the critters are doing, she gets excited for me when I get excited about something that's going particularly well, she's sad for me when someone goes carpet surfing, and she patiently glazes over when I start rattling off Latin names for things. I've asked repeatedly over the years what she'd like to see in the tank, and she honestly doesn't care. She just wants it to look nice. Exactly what I choose to put in the tank to achieve that goal doesn't matter very much to her. She's even letting me set up a 110-gal predator tank and is graciously living with a six-foot aquarium sitting on the floor of the fish room while I build the tank stand.
There are, however, two things that will make her upset about the tank. As many have mentioned already, spending too much time on the tank for too many days in a row will get her grump on. The other is aesthetics - if I leave water change equipment lying all over the room, or if you can't see the fish for all of the algae growing on the front glass, then she wishes that I would find a different hobby.