Locally we are doing pretty well- 12-20 regular players. The occasional new player, or player leaving, but most of our turnover is due to people moving/getting deployed (lots of military around) rather than people quitting or joining, though we have had a few people start playing or get back in after long breaks.

Fantasy is smaller, with 6-10 regulars.

LotR is dead, dead.

No Warmahordes that I know of. Malfeux is starting, and X-Wing is picking up rather quickly, soon to start maybe a league/tournaments for it.

Magic is king though, of course. But 40K is still prince, along with comics.