Rotella 5w40 in my VFR was a 30 weight by 1100 miles, now if all one wants is 30 weight protection for 2,000 miles or so, that would be a great substitute for 30 weight oil.
Im not sure why Honda has dropped to recommending 30 weights, probably energy conservation, more than anything else.