Like you, the painkillers did not relieve my pain. In fact, the codeine made me sleepy and constipated. My GP eventually prescribed morphine (severadol) which did help but made me feel nauseated and very sleepy. I then got an anti-sickness tablet prescribed to help with that! I too was rattling with tablets.
I didn't feel heat helped me and lying down made the pain unbearable. I ended up trying to sleep upright well supported with pillows - which was a challenge!
You're so right about the gambit of emotions that swirl around. I thought I would never improve. It's difficult to accept such sudden attacks of poor health when you've previously been relatively healthy.
A few days prior to my diagnosis I had come off a flight from Portugal. The following day my back pain started. Being a district nurse, I diagnosed a severe muscle strain probably due to lifting luggage. However, after self medicating for a couple of days it got worse and I then started to suspect a blood clot in the lung. I got an urgent GP appt who said I had no air entry in the base of my right lung. I was admitted to hospital where a ct scan revealed pneumonia.
My third X-ray, thankfully, eventually showed that the pneumonia was starting to resolve, after about 3 months. But, it took a considerable time (many months) to feel completely free of pain. It's certainly not something I would want to suffer again. You have my every sympathy Bee. Pamper yourself and accept all help from family and friends. Maybe you could discuss the possibility of trying morphine with your GP - if he agrees, remember to ask for an anti-sickness tablet!
Kind regards. Take care.