I'm from the Scandinavian CMAS club scene, specifically Finland. From what I've seen:
Most clubs seem to own a compressor, and at least 1-2 sets of gear for students. Most commonly there is some nominal fee for a member to rent the gear (free during a class) or to fill a tank. Many clubs can do nitrox, trimix, and other mixed gas fills too. "Clubhouse" space is often provided free by the municipality, because municipal governments tend to see leisure time activities as a quality-of-life priority & worth the investment. Many municipalities also have indoor swimming halls and many halls will provide clubs with their own reserved times to use one or two swim lanes, the whole deep end, one of the pools, etc. depending on the need. Many dive clubs sponsor underwater rugby, underwater hockey or such as fun & keep-fit activity during their club's pool time.
Lots of clubs own boats. Most commonly RIBs, but some club boats are are pretty big and can sleep 8-12 persons. Some larger boats even have sauna because Finns really know how to live
Our club only has about 70 members, but we have a couple boats (a 10m open boat & a RIB) and a couple compressors (one big + one mobile). Membership costs about $70/yr and boat trips about $12/trip. Like many others clubs, our club offers many levels of dive training where students pay the club for classes and all instructors are working as volunteers. Note that our club paid 100% of the bill for our instructor training and any necessary first aid classes, card renewals, etc.
Clubs also generally offer weekly dives throughout the summer months where some more experienced person plans and takes responsibility for the dive event (picks the place, sets the schedule, can decide pairs, etc). More experienced pairs can (and usually do in fair numbers) join the dive event and manage their own affairs as trained and competent independent divers. Weekly dives are an inportant service for newer divers who need and want support - put your name down for a weekly dive and the leader will find you and experienced buddy, make sure you have the necessary equipment, gets your weighting sorted out, whatever you need. The life of the club depends on creating more compent, experienced independent divers so we put a fair bit of real effort into making it happen, or at least making it possible if the person themself wants to do it.
I think the club system works great here. Obviously things could never be like this in a locale where the club and all its representatives would have to worry vastly more about liability, and at least spend vastly more money of insurance for this purpose.
"It seems to me maybes" => "Where did they (clubs) go" might be due to increased competition for everyones free time (meaning more now than 20 yrs ago), decline in general populations' willingness to do volunteer work and willingness to commit to participation. It seems like in the mobile phone age people have steadily become less willing to plan in advance unless absolutely necessary; this makes planning group activities harder than it was 15/20/25 yrs ago.