The Urban Workshop isn't inexpensive. A prepaid Annual membership is $1400.
As mentioned, most miltary installations have an auto craft shop. I think the NPR guys, Click & Clack, actually ran a shop kind of like what you're describing. Doable? Yes Problems: Start Up Costs and Liability Exposure.
In the bicycling world, there are cooperatives and clubs that have workshops and tools.
Even the military auto craft shops have their issues but since the users are either active/retired military or defense department civilians most people behave themselves. However, the modest user fees charged at the auto craft shops don't come close to covering what the facilities cost and all the other associated expenses. Mostly the fees help pay for the staff and expendables.
In the United States, clubs and fraternal organizations with their own buildings have been losing membership for years. Masonic lodges, Knights of Columbus, Elks, VFW, American Legion and similar organizations have aging memberships and relatively few young people joining. Heck, at the youth end of thing, Scouting and 4-H have lackluster membership. With so many options for our free time, we're more of a country of "Do Your Own Thing" and not joiners and sharers.
I suppose the best one can realistically hope for is having friends and family that help each other out now and then.