I got my brain scanned by the MRI scanner a couple of years ago and I thought that it was going to be awful.
I almost enjoyed it, I was taking part in research and they gave me a copy of my brain afterwards.
You will be okay - the staff were really great. I can't remember where I went but it was in Edinburgh.
:-)