DR Ron I am very sorry your MRI was so horrible, also surprised the dye didn't work.
My first MRI too was a nightmare that lasted an hour, and I had taken something to relax me. It was the physical pain that was the worst part, and having no conception of how much time I had left in there.
I am very surprised being clauserphopic your doctor didn't prescribe something for you to take. Nothing or completely out without an inbetween option.
My MRI times are shorter now due to better equipment, and I no longer need anything to calm me. I can't even count how many times I have done them.