As weird as this sounds, I'm actually thinking that the mansion from The Rocky Horror Picture Show
would be nice to live in. So many cool things in there - a pool, a fully equipped lab, a way to make people stick to the floor, all kinds of interesting stuff. Also, the furnishings, etc., are very fancy and for a final touch, apparently the whole thing can be used as a mode of transportation.
Granted, I am not so sure I would care for the company very much. But this thread is about houses from movies, not families from movies.
P.S. If the present occupants would relocate but leave their wardrobes behind, that would certainly be another bonus!