Again, they use it all the time. There are 1000's of scopes done in the USA everyday, most people do just fine.
If your really concerned, you could do it unsedated, its not fun, but dosent really hurt, and only lasts 3-4 mins, plus you can go right home.
And with MJ, def totally differnet. You will do fine. Ask your doc about any concerns you may have.