A house really is a game change IMHO when it comes to this hobby. And I know exactly what you mean, every house I looked at having room for a fishroom was a primary consideration. I personally looked for a basement because I wanted a place away; a man cave. I figured the girlfriend would pretty much control most of the house so I wanted a place of my own, a retreat where I could be a man unfettered. lol
Definitely, i'm sure! Knowing that I won't have to lug my aquariums and fish every few years to another location will allow for much more flexibility. I find myself looking for the "prime" locations for aquariums at any house I go to that it's become an inside joke with my fiancee. Pointing at a wall and saying "right there" and she knows exactly what i'm thinking about. Unfortunately, basements aren't common where I am, but maybe that's for the best. I don't think I could ever manage the upkeep of a true fish room with multiple racks of tanks.