Our first diesel motorhome was a 34-feet Monaco Windsor DP with a Cummins 350 hp engine. We loved it! This engine also was used in larger 40-foot motorhomes and I suspect the extra weight would make them a little less spry than ours but certainly adequate in most circumstances. Incidentally, the decision to upgrade from gas to diesel was made as we were going up I-70 toward Eisenhower Tunnel which is over 11,000 feet in elevation. As we were chugging along in our Chevy 454 and being passed by lots of diesel rigs, Jerry said "I want a diesel pusher." We found the Windsor the following year. Yes, it was more expensive than a gas engine. Jerry changed the oil and lubed it a couple of times but we don't recall how much oil it took. We eventually moved up to our current Monaco Executive DP which is 40 feet in length, weighs under 40,000 pounds, and has a Cummins 500 hp engine and, guess what, we love it even more! Jerry did the maintenance on it once and it took (without going back into our records) about 40 quarts of oil. We use synthetic oil and that costs more than the regular oil. The oil filter is quite a bit larger, about 7 inches in diameter and maybe 1.5 feet in height. If you change your own oil you have to have a really large container to drain the old oil into and then a way to disperse/funnel it into smaller containers that can be recycled. Our recycling trucks have oil reservoirs and we spread it out over a couple of weeks so they're not overwhelmed.
We've reached a point in life where Jerry doesn't want to do all that anymore so we pay to have someone else do it. We were lucky to find a guy who comes to the house and changes the oil and lubes the Zerk fittings. I think the only other two big things were that the charge air cooler had to be replaced and the closed plastic container that holds the radiator coolant had to be replaced. The charge air cooler was still under warranty so we were lucky it didn't cost anything but time. Jerry ordered the coolant container and replaced that himself. If we're traveling and need to have any service like an oil change we find the nearest Cummins dealer. We passed 102,000 miles last summer and it's still running beautifully.
I guess the best way to put it is that as you move up to heavier engines there will be more cost in terms of maintenance. But that might be offset by other factors such as liking the ability to move heavier rigs up mountains.
ArdraF