Kids are spread out at MSU, Indiana and Colorado, and he and wife travel around and stay in this thing during football season. He's a MI undergrad, so they also use it for tailgating at UM. I've been in it, and four of us used it once for an ND game. It was nice and pretty comfortable.
Anyway, he loves it, but says he'll probably get rid of it when last is done with school. He had to convince his wife to do it, but once she accepted it, she's been cool with it. He said it is perfect for weekend getaways, but longer stays could get a little cramped. Also, seems good for Summer and fall, but might be more of a challenge in winter, especially in snow.
They are in their 50s and he's said it would be tougher to do in 60s just because it is cramped, and requires maneuvering. Also, getting it where you are going isn't cheap. Single digits/low teens for MPG. It's also not super practical to drive around town in that it is fairly large to park.
So, I'd say you could swing it as an adventure for a few years, but depending on your age, duration of stays, and when and where you plan to travel during the year, there might be some downsides.
Link: Thought they were cheaper