Either one will work. You don't need to worry one bit about ending up with an overpowered motorhome. If you have a Ford chassis, you will almost certainly get the V10, and it's a fine engine, smooth running and reliable. The Ford V8 would get you there, too, but struggle more on the hills etc. and probably not get much if any better gas mileage or have any significant differences in maintenance expenses. (For what it's worth, the current V8 is rated about the same as the V10 is in my '98 class C.)
If you have a Chevy chassis, it's the General Motors V8, and it's also a good engine.
It probably goes without saying, but traveling alone or with another person makes rather little difference in the strain on the engine in a motorhome. Adding a few hundred pounds of weight (for the person and their clothes and belongings) to a vehicle that weights 13,000 or 14,000 pounds is barely noticeable, and the air resistance is not changed at all.