I have a few friends at Google who, after working there for close to 10 years, now are thinking about retiring to Portland, or Vermont, or North Carolina. The idea has certainly crossed my mind, that if I wanted to live in a rural area I could buy a house free & clear and be set for the rest of my life. I met an innkeeper in Alaska once that had worked in tech for 20 years, lived like a grad student, and when his kid was a teenager, bought a sailboat, sailed around the world, and came to settle in Seward, Alaska because they'd fallen in love with the town. I've heard it's pretty common in investment banking to have "your number", work for ~10 years until you hit it, and then retire to Fiji.
I don't have a target net worth or age for when I'll call it quits but the way I see it, I'm buying flexibility for the future without sacrificing any happiness today.
Don't try to settle in the NY metro w/ a family unless you are in finance, your quality of life will suck. If you aren't living in the city there's no point to being here, I would much rather be somewhere like Utah, California, Wash state.
My family gets to hop on the Amtrak and enjoy the cultural advantages of NYC about once a month. We drive to places like the Bronx Zoo and Boston for various things.
When I was a kid in Queens, getting to Manhattan via transit easily took 2 hours. My son gets all of the benefits of not living in NYC, and many of the advantages.
Not everyone's choice of lifestyle, but it's certainly a nice one.
You really don't need to go that far. In fact, you shouldn't. You'll hit Lake George and the prices will start to go back up.
An hour or two out and you'll be closer and the houses are just as cheap. You can also go West into NJ and you'll experience the same price drop.
The problem is that you'll be 30 min away driving from a decent grocery store. In fact, you'll be 30 min away driving from pretty much everything.
If you define the "cool" part of NYC as being in Manhattan, once you have a family it's irrelevant, because you can't live there... like 98% of everyone else, you end up in Jersey, the boroughs, or Long Island. Three hours north of NYC, a house costs 60-80% less, and you have the essentially the same access to NYC cool stuff without the hassle of NYC.
In my case, paying 7% of income for a mortgage on a nice big house that I will own in 15-20 years and banking savings is more appealing than some interest only loan on a $750k raised ranch in a big metro area. Barring building a successful business, a lottery-style liquidity event or selling your soul to some hedge fund, I don't see a reliable way to live in NYC, SFO, etc and coming out with any wealth.