I grew up in Schenectady, and I'd like to add some anecdotal evidence against the "can't do that here" attitude, specific to Schenectady.
I know a few real estate investors in the area. One is my father. He started in the 80s with a duplex in downtown Schenectady - house hacking way before it was cool. Got demoted at work, said screw this and focused on real estate. Fast forward to today, he has almost 200 units in Rotterdam and a shopping center. He gets some crazy cash flow and is looking at if he wants to liquidate anything to retire.
A friend's father started the same way - a duplex downtown, but a different approach. He was a firefighter that wanted it more passive, not another job. He slowly bought a few building in downtown Schenectady. A couple years ago he sold what he had and bought a house in Arizona to retire early.
So it can and has been done there, even with all the high taxes and other excuses. But its a long game. Learn from the successes AND the failures, and best of luck to you.