I have not had a c-section, but I can answer a bit of your questions.....
a spiral block does NOT put you to sleep....it will knock out sensation and if you're exhausted then you may fall asleep if you've been having contractions, but since you're scheduled to get a c before labor starts most likely you'll be wide awake through the whole thing.