I've had two - EMCS (although it was about as un-emergency as you could get) and ELCS. Both were absolutely fine.
I'm a big fan of natural birth and had a natural birth with DC1, but was honestly left with no medical choice after that due to cervix issues.. even me, the big fan of "natural birth whatever" knew it was a no-go.
You feel really oddly detached from what they're doing down there, and anything you do feel is not pain, just "something". It's not freaky at all.
The only bit I didn't like is when I try and move my legs and they don't move, and then of course I try again and end up in a vicious spiral of "argh, legs!" but if you tell someone they can distract you easily enough! Baby is a pretty good distraction and as mentioned shows up very early in the proceedings! And the numb legs thing applies to epidurals during a vaginal birth anyhow. And also seemingly I'm the only person who has this issue with numb legs anyhow as nobody else ever reports it..
It's all so relaxed and chilled and everyone is always super friendly and cheerful. Most of the time you can get skin to skin afterwards too, especially if you put your gown on the wrong way.
The recovery is not great obviously, but often vaginal births can be horrendous to recover from as well. And you get better drugs with a c-section.
This one has to be ELCS again.. kind of looking forward to it!