They probably had to give you a strong dose to control the pain. Generally if you take too much with a low tolerance you aren't going to have such a good time (even though you definitely won't be in pain anymore). If you hadn't been in so much pain and had been given a smaller dosage at first, you would have probably felt more of a euphoric effect.