Yep, been there, done that, got the t-shirt. :-)
Your story is pretty much my sad tale. I destroyed my left ankle in a motorcycle accident, and now do OK, although "I had to give up the ballet." - Sorry, bad joke, but I love saying it. But, like you, I enjoyed the feeling I got on Vicodin. At first it was "a reward," for getting the yard work done, or following the wife around the mall, whatever.