Are CVT transmissions still a joke?

Hi all, a rather non PH question if I may?

I've been a very happy owner of a Nissan X-Trail, a 2008 T31 model. Bought it 8 years ago for towing duties as I had a garage business then (now retired), bought it for not a lot with 113k miles on the clock, it's now on 172k miles and running fine. It's just taken us down to Devon, 200 miles each way, loaded up for a weekend away and for marshalling duties on the Lands End Trial, whereupon it got very muddy as usual, but has cleaned up nicely both in and out as it always has. Myself a couple of mates have been doing some marshalling on trials and stage rallies, and the X-Trail has been bloody great. Cruises nicely to and from (not great on the twisties in Wales though )

However it's an auto, a good old traditional slush drive job, and I do like an auto for mundane driving duties. I want to buy a younger X-Trail, poss post 2017 facelift, but all the autos are CVT. The likeliest alternative to X-Trail is RAV4, but they're CVT too (I'm aware the latest are now trick emotor-no-belts-type but they're too new).

Does anyone have any experience of CVT transmissions of late? Are they still absolutely sh*t, they have terrible reputations, not undeservedly, even the Japanese have struggled to make them reliable.
I could go manual of course, which I would find frustrating, and as I like to keep cars a long time I'd probably be into a clutch and DMF replacement once in it's life, but CVT transmission failure writes a car off, I would imagine.

Any thoughts or advice guys? All replies greatly appreciated.