I'm due to have one and not allowed sedation due to being pregnant. All I've read is horror stories and I'm so nervous! Someone please say it's not that bad without sedation?!