I love density and urban living. I've lived in lots of apartments over the years. I currently live in a single family home. Having a house and a yard is absolutely awesome:
1. I get acoustic isolation from my neighbors. I don't care when they watch loud movies. They don't care when I make music.
2. I have green space that I have autonomy over. Shared parks are nice for being a passive consumer of green space. But a personal yard means I get to be an active participant in its horticulture. I can garden, which has shown repeatedly over the years to be good for mental health.
3. I have more windows that let in more natural light when I'm inside. My living space is more seamlessly connected to the outdoors. I get natural light on all sides of the structure.
4. It's easier and more efficient to let my dog out in my own fenced yard.
I don't think people need huge sprawling yards to get most of this benefit. The UK model where everyone has a little garden behind the house is probably sufficient. But I do think Americans are generally smart enough to like single family homes mostly because they like single family homes and not because they have been hoodwinked by some nefarious pro-suburbia organization.