What specialist have you consulted? Have you been to physical therapy? Was your lumbosacral spine examined or imaging done? Do you have history of any trauma or accident?
This is mind boggling. Just a Hollywood script. But gave me a clue and indication for the diagnosis. I was perplexed with your amount of pain being just 40 years of age.
The first thing in consideration obviously would be osteoarthritis. Second would be looking for avascular necrosis. I would also look to your back for causing aggravation of this problem by some abnormality there, like scoliosis and pinched nerves there. An MRI is better investigation than the CT scan to assess the joints and back. Apart from MRI, according to the findings, bone scan may also be needed. Braces (you must be knowing very well about them), deep electrotherapy (electrical stimulation, iontophoresis, phonophoresis), physical therapy, analgesics, etc would be helpful.
Please feel free for your follow up questions.
All these chronic conditions many at times do present with acute onset of presentation, when there is abnormal weight bearing. Without an examination, it is difficult to give you the diagnosis, but bursitis of any sort has some pain free movements and weight bearing should be not so painful.
I won't agree with your steroid treatment. In the absence of diagnosis, it is not indicated. But some Lortab and Percocet is indicated. TENS is good and you can use it as much as you can, although it too has some tolerance. Not much, I can say as a home treatment but local analgesic patch should be helpful. So do the hot fomentation or Ice (according to your preference).