I quit playing CS competitively a year before CAL/CPL died which was about 5 years ago. I was pretty deeply involved in the culture and don't regret the few years I spent on CS. I think you have to look at it with a realistic perspective though, most of us were 13-19 year olds who had too much free time and didn't have to pay any bills. On top of that going through college or having a job gives you a whole different social reality that can be infinitely more rewarding than a virtual one.
That said I've met a lot of older people who play WOW in their spare time. If there is any real money left in competitive gaming it's probably in SC2. I barely play PC/Console games anymore but I do watch JustinTV gaming streams which for some reason I can't get enough of. All last week I had a stream of some guy playing LA Noire in 720p playing in the background while I was working. JTV just posted for applicants on hacker news a few days ago talking about building a huge esports site(probably with SC2 in mind since it's the most popular game on there by far) so there's money being made somewhere.
I'm looking at http://www.gotfrag.com/ right now and it seems pretty alive. Lots of WOW and SC2 in the news, CS/TF2 in the forum. I heard TF2 is pretty fun in competitive play and I can understand why.
Unrelated rant: Looking at the gotfrag site reminds me why I've always disliked the "professionalization" of gaming. The people responsible for running the websites and tourneys have a bad habit of trying to emulate real sports business practices in an attempt to legitimize their efforts. As a result you get SC2 broadcasters who think that success means communicating like you're Marv Albert (NBA commentator) or overemphasizing parts of the game that are marginally important but help promote the ill-conceived fantasies of a guy who watches too much SportsCenter.
Gaming can be successful as a spectator sport but only if the key people stop trying to shoehorn it into a world it doesn't belong. I understand that no self respecting adult wants to be directly associated with cheeto fingered 13 year olds but they're going to keep fucking up until they find a different model.