As an RN, I have to say that the ability to get off the narcotics is going to vary a LOT from person to person. Likewise they don't make everyone feel stupid; they don't affect me mentally at all. The key is to use them enough to exercise properly, which will make you stronger and reduce the pain so you need them less and less.
I had a hip replacement and shopping for RVs this past week, which of course required me to walk up the steps to get into them, was ... interesting. ;) I had to collapse and rest for a while in every one we looked at before I could look around. But I *can* get into the one we are buying and wanting to hit the road will be motivation to work harder at steps!