I've actually thought about it quite a lot. Though rather than using a house, I've considered doing this in a large round building like a grain silo. The helix would be along the inside of the outer wall, wrapping around the entire building. If the silo was 30' in diameter you could maintain less than 1.5% grade and have more than 15" between decks - effectively making the helix a usable scenic'ed area. It could be two feet deep with rolling hills, buildings, trees ... all the typical stuff. Just that it'd be averaging a 1.5% grade continuously in the same direction.
So then you've got a helix wrapping around the building, potentially several floors worth. The center of the building could be platforms where the helix track splits to a little town that either the main line runs through or is a branch line.
Using this same notion, you could have the "helix" be a "nolix" (I dislike that term) that wraps around some larger room or perhaps several rooms. That way the act of climbing to the second floor is actually viewable as a big mountain climb. Looks like you'd need 600' to climb 9' at 1.5% grade, and I don't think I'd push a climb that long at much more grade than that. If anything comes loose it's going to take off like a rocket.
The other nice thing about long runs along a wall is you can clear floor joists if you need to. I'm not so sure the holes in the floor are such a big deal since you have to use stairs to get between floors anyway.
I've also seen plenty of train elevators as well. Here's an example:
http://www.dccbydesign.com/top-blog...ro-ro-train-elevator-explantion-a-review.html
I think it'd be fun to build a two floor train layout. But you're talking about a spectacular amount of track. The layout at the club I'm a member of has track that changes elevation by more than 6', but I'm not positive of the actual difference. It wiggles around a 60x70 room several times in order to make that happen, though.
I too think it would be most fun to do in O scale. Because it's traveling so far in potentially difficult to reach locations the larger scale would provide greater reliability. It would also provide more powerful and reliable locomotives for longer climbs.
Let me know if you want to get started - I'll bring my tools