The club concept is a good one and a great way to bypass the commercialization of diving but... it takes effort and commitment and that isn't always forthcoming these days. Many people prefer the notion of just "paying" for their experience because it frees them up to come and go as they please. Lot's of people have the "serve me" attitude instead of "being of service" attitude which is what the club scene should be all about.
My personal experience with clubs has been poor and good and was motivated by a search for other dive partners like the OP. Initially I was part of the creation of a very effective email dive buddy group (pre facebook), the members of which still dive together occasionally. This email group formed a network of friendships for many divers in the lower mainland - many of whom have moved on to other groups - and it allows those different groups to communicate with each other through us.
Around that same time I joined and was part of starting an LDS based club that took in money, promised a lot in terms of structure and program, then petered out fast because of a personality/ego/control conflict. The LDS owner tried to smooth things over (it wasn't he who was the problem) but the damage was done. Apparently no one likes to volunteer their time and effort to a dictator (no, it wasn't me).
Then I found an older established club that was going somewhat dormant (diving wise) but still active socially. Some of us joined that one, whined to ourselves about the lack of diving, but stuck with it long enough (and dived anyways) to see it eventually turn around. Now it's active once more.
This is a pretty normal cycle to see as clubs rise and fall when clumps of divers move through them and it is a skilled club indeed that can keep itself viable as those cycles occur. It means giving up the reins of power to the younger set while still being there to offer guidance, structure and support. Truth is, old blood often initially resists change and a club can lose older members when it occurs. I have to give our current Pres. Michel a lot of praise for helping our group through the latest transition. He has a way of maintaining leadership while at the same time making each person feel good about their contribution.
So, if you are looking for a club my advice would be to get ready to roll up your sleeves and be patient with the old crusty's. With these things it is often more of a marathon than a sprint. If you find a club, dig in, find one area where you will contribute, and try and focus on the good and not the bad.
A shameless plug for our club can be found in my signature line