I've lived in both a large house and a tiny apartment, and there is just something super appealing about living somewhere that you can understand at a glance.
The only thing I didn't like about tiny studio apartments was the inevitable lack of noise isolation.
Now, my dream is to live in a house that probably is just a little too big to qualify as "tiny," but the house is on a decent piece of land. Basically a nice cabin in the woods sort of house, but without the horror movie connotation.