I had an elective the first time and an emergency the second (failed VBAC)
Scary: the elective not really scary at all. I felt apprehensive and excited, but the atmosphere was very calm and friendly, it was overall a happy experience. Was a bit odd climbing onto the operating trolley myself. The emergency, not surprisingly, was quite scary because by that point the baby's heart was decelerating and I was exhausted and there was definitely an air of urgency and maybe even danger in the room.
Painful: Yes, I'm afraid so, both times. The EMCS took a lot longer to recover from, partly because I had been in labour for so long, partyl because they really had to bash me about to get DD2 out, and partly because of complications. I did find the pain quite shocking actually, although I suspect I have a lower pain threshold than some. However, both times I recovered surprisingly quickly and was back to 5k runs at 6 months post-op.
Dangerous: Apparently so, but in my (admittedly unscientific) view there is something of a spectrum whereby the safest mode of delivery is unassisted VB, the most dangerous is EMCS, with elective probably ranking above some complicated VBs. My own experience of EMCS was not great, I had an organ cut through and had to have GA following DD's birth while they sorted that out. If they hadn't noticed before they sewed me up I'd have been in the same position as jellybeans.
I won't be having any more babies but if I did I would have an elective section. It was a calm, positive experience.
I hope you don't find this too frightening, I have tried to reply to your questions honestly.
Good luck with your decision.