ABQ is not quite Wild West, but you do need to watch yourself there. Good farmers’ market and plenty of Native influence.
Columbus downtown seemed like a nice Midwestern spot, touch of Rust Belt, heavy on Buckeye mania of course. Seemed really quiet when I visited many summers ago.
Have you considered Chicago? Boystown is a great neighborhood. Kinda wished I’d lived there even though I’m not LGBTQ. I think it’s still relatively low crime. But I’m sure you’ll want to do (or have done) your own homework on that.