My doctor said I could be awake if I wanted, I guess in that case they just give you something to make you relaxed and mellow but it doesn't put you out.
I had no issues with the propofol, it put me right out. Like, when she plugged it into my IV the nurse told me it might burn a little and that was normal and then BAM! I'm opening my eyes back in my little exam room. No nausea, just a little grogginess and I was able to walk out of the building with no problems.
However they did tell me not to drink alcohol, drive, or sign any legal papers until the next day!