Was a big Club Med fan up until kids grew out of wanting lessons. I have a couple of posts in the Kids section about how great I thought their set-up is.
It's best value if you want to take advantage of the lessons: don't fear that it's beginners only; you're put in groups according to your ability and experienced people will end up doing black runs and tree skiing with an instructor who refines your technique but also leads you to some trails you wouldn't have necessarily thought of. There's 2 x 2 hours sessions a day and you can do as many or as few as you want, you're not locked in.
Terrain will depend on what resort you're at: Sahoro in Japan (our usual stomping ground) is effectively a private mountain with only 28km of piste, but the various ones in the French Alps for example have access to the entire 400km+ of piste in the given resort.
Whether or not it's too late now depends on your budget: as we are restricted to school holidays I've always booked the instant that the 30% discounts are offered in January. If I left it to now for the dates I need I'd be paying horrendous prices. If you can get the weeks that aren't in high demand you may be in luck $$$-wise.
Generally the bar area is great for apres-ski and that's where everyone meets; my experience is that most of the seating is communal so you're going to meet people and have a good chat. My husband sounds a bit like yours but even he ended up striking up a bromance with a Bosnian ski instructor and being very social indeed. The instructors make an effort of mingle and will sit in your group and chat, and even join you for dinner and I loved that, it's a really homely environment despite the number of people.
Skiing tends to be the priority from the resorts I've stayed at; mainly because they're fairly isolated and there wasn't really too much else you could do. However, this will depend on the individual resort and what it's in proximity to; Tomamu (the nearest other one to Sahoro) has ice skating and wave pools and other things, Peisey in the Alps has the entire town on its doorstep. If you're one for cultural stuff and apres choose carefully as there are big differences between them.
There are some notable exclusions: transfers to the airport are excluded unless you book the flights through Club Med also, then they'll add them; these can be pretty exxy so it's worthwhile seeing if there's a private transfer available.
On site equipment hire in my experience is pretty steep as well. The Japanese resorts you don't have much option unless you want to hire in Sapporo and drag them with you, but the French ones there'll be a Skiset or an Intersport locally which will likely be cheaper.
European resorts for the most part are locked into the weird 7 day blocks that is common there; last time I looked Peisy and Valmoral were the only two that weren't (might have changed since). However, a CM rep said that later in the season if they're not fully booked then you can book 8 or 10 days or whatever. The Japanese don't do this and I've never looked at Canada to see what their model is.
In terms of cost of CM vs doing it yourself, last year I ended up doing a trip to France myself as Japan hadn't opened its boarders in time for us to be comfortable so we cancelled the booking and flights and went to Europe instead. In terms of cost it was significantly cheaper doing it ourselves, but at the same time it was oranges/apples as I didn't book lessons, the food was crap with husband cooking and it was less relaxing and social. It's altogether a completely different experience.
TBH my kids and husband don't want the high-quality food the CM offers (and my god was it awesome: venison, king crab, fillet steak, local delicacies), and I've cut right down on alcohol so don't really want to be paying for an open bar (Shot night was good though). I'd still do the lessons but they kids don't want to anymore so it's dropping in value for us and the next two years I've got planned are / will be independent travel.
I'll always have a deep love for CM and will summarise it as: if cost is your driving factor, it's not for you, you can do it cheaper yourself; if having zero hassle in organising and a lively, social experience appeals then give it a crack.