As others have said, in the 900, it's a waste. Higher octane prevents detonation so it enables more compression and more power. It is not the source of power, it's simply an enabler (like a heavy duty rear end in a hot-rod. The heavy duty rear end doesn't increase power, in fact, it's weight and friction decreases it, but it enables 1,000 horsepower+ engine output because it can withstand that type of force against it.)
Higher octane allows an engine to produce more power without damage. However, our 900 engines are not doing any of the things that we would need higher octane for (higher compression, forced induction, etc.)
Also, a quick comment: The manual recommends 91 RON, which some people get confused on. 91 RON is basically equivalent to 87 R+M/2, which is the standard of measurement we use here in the United States. So if you're in the US, use 87. Higher octane provides no benefit, you'd just be wasting money.
If you want your engine to stay clean, run a can of seafoam in it every once in a while. It'll clean your fuel system and eliminate deposits better than any fuel will.
I have a hard time believing people on VN900's who claim to be getting better performance aren't just tricking themselves into believing it, or there is some other variable (like different batches, different gas stations). I mean, I wasn't there, I don't know... but it doesn't fit with the science and it doesn't fit with my experiences anyway (Octane doesn't modify performance, in fact, because higher octane fuels are harder to burn, which is the precise reason they don't ping in high compression engines, they should actually reduce power).
I dunno, maybe those folks have better butt-dynamometers than I do

, but it doesn't make any sense that higher octane would increase performance or cause a VN900 to run smoother. Maybe if it's been well modified, but definitely not stock.