Awake or Unconscious during C-section?

L

It just occurred to me that if I have to have a C-section I have the option to watch/be awake. But the idea of being awake while someone cuts me open makes me nauseous. But I can see how it would be jarring to go to sleep pregnant and wake up not. SO, any mamas who had a C-section want to weigh in? Were you conscious or not? Is it super weird to be awake during the surgery? Was seeing your baby come out worth it?