I'm looking for the same thing, maybe we can compare notes!
I've been going to the Capitol Hill Tool Library lately, which is my local makerspace. The space is small but they have a lot of traffic and people are generally very friendly and helpful. Also they have woodworking tools which I would never have in my apartment.
In terms of makerspaces specifically I imagine the limiting factor is rent. When rent is too high you end up with a smaller space and less cash left over for equipment.