While, for obvious reasons, I've never had a hysteroscopy, I have had a day treatment op under general anaesthetic fairly recently. Like you, I wasn't looking forward to it but it turned out to be an absolute doddle. I simply had a small, painless injection and quickly fell asleep. In what seemed like no time at all, I was waking up and fully conscious in just a few seconds. I had absolutely no nausea or dizziness at all. Indeed, if they'd have let me, I could have walked out of the hospital, feeling fully fit, right there and then.
So, comparing my experience with those of those mentioned in my link above, I reckon that opting for a general anaesthetic might well be a good idea!