If you're a certain type of person, yes. Miles better.
You have rows and rows of blocks catering to specialty commerces, astounding, world-class food for ridiculously reasonable prices that can't be obtained anywhere else, a huge amount of access to employers and jobs that are also nonexistant outside of a few large cities. You don't need car ownership; you're trivially close to international airports, and the cultural scene is, once again, not available in smaller cities.
Having spent almost all my life in large cities, the suburbs are just terrible boring, even if your place to live is 5x bigger.
Obviously if you like the outdoors that situation may be very different, but not all suburbs and small cities have access to outdoors recreation, and not all big cities are that far away from excellent parks.
To give just one example, I tried signing up for improv comedy lessons --- and I found that my teachers were among the best in the world, and that they had a range of lessons available ranging from beginner to master. In Columbia, there were beginner lessons only, and then the instructor flaked on us -- so now there is nothing.
From my perspective (30s, single), paying SF rent was the best investment I ever met. In SC I do indeed own my home --- but I find myself saving half my salary, not because I am either unusually well off or frugal, but rather because there is nothing I terribly want to spend money on.
I personally cannot fathom why one place can be son much more expensive than another. Sure, there is a price differential, but is SF really that much better than Brimingham, or Durham, or Albany?
Besides, if you want to be the master of your destiny and put a root down, buy. Renting is a tool for when you cannot afford to buy yet, or for when you are on the move. It's greatest strength is that it lets you up and move. I never understood why you would rent the same place for more than a few years. If you plan on staying, buy. If you cannot afford to buy, why are you staying in this place?