Buffalo is no longer a boom town, but it is still a thriving metropolitan area–particularly its Northern suburbs, where the main frum communities are located.
Compared to a few decades ago, it has lost population, but the economy is not bad. For example, the unemployment rate is 5%, the same as NYC. Jews are successfully working in all the fields you’d find anywhere else — medicine, law, accounting, business, real estate, chinuch, kiruv, etc.
The frum community is relatively small but growing, and is exceptionally warm and friendly, with first-rate rabbis and learning opportunities and an increasing number of young couples with small children. You can buy a four-bedroom house a few minutes walk from shul for 200k, in extremely quiet and safe neighborhoods with a kosher eruv.
What kinds of things are there to do in Buffalo? Similar to what you’d find in any city — the zoo, many beautiful parks and natural areas (Eternal Flame Falls is highly recommended), museums, the waterfront, restaurants (Nissan’s and Tel Aviv Cafe are the only two kosher restaurants, aside from Eli’s on campus), etc. And Niagara Falls is just half an hour away.