You really can't make a categorical statement like that. I prefered living in an apartment because the housing density meant I had a grocery store, a farmer's market, and multiple other commercial hubs within walking distance. It also meant that street planning gave priority to public transport and pedestrians. There were plenty of jobs available within reasonable commute times. My neighbours gave me an easy-to-access network of people that you could befriend and somewhat rely on.
There's so many positives to living in an apartment that are pretty much direct effects of the denser housing.
SFH IS the best options, nobody WANTS to live in an apartment if given the choice.