All motorhomes ride rough, from the million dollar ones on down to the less expensive ones. It's a matter of weight, and the necessary suspension parts to support that load, tires and shocks among other things. If you can ride in a city bus for all day, you can ride or drive in a motorhome all day.
However, if you need serious pain medication to keep it in check, you have no business driving the rig, you are an impaired driver under the influence of pain medication which can and do affect your ability to be a safe driver. Please give those concerns serious consideration before you attempt this.
Driving a MH is not like driving a car down to the grocery store, they take lots more concentration and attention than that. Please give that some thought. Otherwise, like said, if you can ride on a city bus all day, you can do the MH thing.
I would recommend since it's been 10 years since your last excursions in the RV world, you take a safe driving course for you and the co-pilot from a Commercial Truck Driving Instruction Center to refresh your skills. You will learn lots of things you never knew you never knew, and be a safer driver with that large rig. I had to drive big rigs for my work, but every few years we take a safe driving class to refresh what we have forgotten, you would be surprised how much we learn in those classes.
Monty & Janet - 2007 Alpine APEX 40 MDTS
S/N - 75715 - Retired - Master Certified RV Tech