It's a long time ago now, and I'm still living the consequences. I had masses of cover and, when things went pear-shaped, was grateful that I could still pay my bills & mortgage. I also got counselling via BUPA to help me cope with the sudden reversal of fortunes.
However, I hadn't paid enough attention to the pages of tiny-print clauses. Before two years were up, every single policy had found a reason to stop paying out and to ban me from future cover unless I paid absurdly large fees, which of course I couldn't afford (and wouldn't be worthwhile if I could).
My illness wasn't defined as 'critical' so I never qualified for a large payment that could've stabilised my situation.
So - yes, it's worth having for a modicum of security BUT you must realise these firms are not there to look after you! They'll leap on any reason to deny claims, and to cease cover. They've foreseen most of these reasons, and you sign away those rights when you begin the contract.
If you really want to be covered, you need to have savings & investments that would fill the gaps in a worst-case scenario. Depending on your circumstances, it may be better to do that instead of taking insurance.
It's also true that private healthcare instantly defaults to NHS critical. This makes me very angry, ever since I realised an ambulance was on standby to take me to an NHS hospital when a BUPA surgery was taking too long. It was nice to be comfortable and solicitously cared for at the private facility, but wtf? Whoever signed that agreement on behalf of the NHS was a sucker! Or, probably more likely, being paid on the down-low.
@Appleofmyeye2023 made good points, imo.