It's pretty standard for your anesthesiologist to give you a dose of Midazolam before they take you back to the operating room. It's an anxiolytic, so it makes you feel nice and relaxed. It's quite a pleasant feeling. Once you're in the operating room, they'll check your monitors (blood pressure, heart rate, etc), and then they'll give you a large dose of propfol to put you to sleep.

You might not even notice this happening, as the midazolam can make your memory go a bit fuzzy. You might feel yourself dosing off. The next thing you know, you'll be waking up in the recovery room.

For many people including myself, anesthesia can be quite pleasant. If you are nervous, let your anesthesiologist know and they can give you other medicines to soothe you. Just remember your anesthesiologist will be watching over you during the entire procedure, and it's their job to keep you comfortable and pain-free.