In general I like the discussions, and of course the wide variety of Civ-related information and content. It's the latter that really keeps me coming back, but the non-civ-related topics are interesting enough to dive into occasionally too. And there also have been some cool community-organized events over the years, ranging from succession games (not always even in Civ), to meetups, to sending a camera or stuffed animal around the world (albeit unsuccessfully). Even people I've mentioned that to who aren't involved in Civ or online forums at all have thought the last one was an interesting idea.
I mostly agree with Thorvald of Lym about there not having been enough community involvement in the XenForo change. A good amount of links and threads were broken that might have been avoided had it been done a bit more gradually, and organized a bit better than (mostly) one big thread. And I'd like to see more effort by administration to keep the site vibrant in general. Narz's first like is IMO accurate. But I suspect there is room for a more active administration to help with keeping CFC vibrant, interesting, and relevant in the age of Steam. Moving to XenForo was a necessary step to keep pace technologically, but (unless you could moving off of TeleFragged's servers when they shut down, which was a necessity) it's the only major change I can think of in recent years. I've been thinking of starting a thread on that topic for a week or two, but real life has distracted me.
On the balance I think the no swearing rule is a positive. While it can be moderated effectively, there are other Civ sites that allow it, moderated it lightly, and their off-topics have become cesspools that I have no desire to wade into, and which don't seem to add any new members. So while occasionally it might make a point a little stronger, on the whole I'd rather have the current system than try to walk the line and wind up with toxic sections of the site.
I am glad that old threads aren't locked automatically after a number of months, as I've seen at some other sites. Especially in the Civ sites, useful bumps of old threads do happen. Necros of staple threads, like Fifty's "Whatcha cooking tonight?" also are allowed, even if they've been inactive for months.
All in all though, I really like CFC (and everyone who's responded in this thread has been a member 10+ years, so that's probably true of all of us). I just hope it remains relevant, perhaps especially for the newer Civ games where there's more competition for the community.