For one or two years use, I would buy in at 7 to 10 years age, as the value will not change much in that short a time, particularly if you have patience to buy carefully and sell casually.
Brands, models, whatever fit my needs at the time, $100K probably a whole lot more than what I would need. When I was shopping in 2004-5 my needs would have been well met by 30-32 foot A gassers (Fleetwood's Bounder, Flair, Southwind Storm lines, Winnebago Brave, Damon Daybreak etc) or 28-30 foot C's. Even today, $30-50K will buy a lot of really good, really useful motorhome in the age range where depreciation has mostly leveled off.
$100K might get you something really nice in the 10-20 year old range, something that might cost a million to buy new today.
There is nothing you can buy new today for $100K, use for two years, and expect to get your money back.