To elaborate on my 'nope' up above, I could not be comfortable or happy in a small space in the current phase of my life. Heck we just doubled the space of our home and I am LOVING it.
Having said that, my (older, half-) sister and her partner live in a caravan for the summer months, and a 2-room house they own for the winter, and rent out over summer. They live in a fairly popular tourist part of the country, so have no trouble renting out the house, and also the winters are jolly cold, and their caravan was not much fun the first time they tried to winter in it.
She LOVES the caravan, says it feels like she's on holiday all summer, even though she goes to work each day, and she loves how little cleaning there is to do in the place. They have storage in the garage of their house.
But: no kids, no pets, no space-taking hobbies, just the two of them in a permanent site at a caravan park, with a deck and a tiny garden around them. And only for the good-weather half of the year.
For me: almost 4 kids, quilter (thus fabric stash, machines, works in progress...), gamer husband (thus, many board games and shelving for MtG), homeschooling (thus books and more books, and all the kids' works in progress...) I say 'no way'. But we won't always be at this life stage, and who knows what we'll choose once the kids have flown the coop?