Different vehicles / engines will respond differently. My experience is that fuel-injected engines with a half sensible ECU will be better setup to make the most of higher octane fuels. Some performance derived cars will naturally perform better on higher octane fuels.
I'm sceptical about higher octane fuel in the Fazer - I tried 97 RON once but the bike didn't seem overly happy with it. However, I'm happy to give it a bit more of an extended try so for the next few fill-ups I'm going to try out Shells V-Power and see what happens - my engine can't get much worse
For those that are interested, Fifth Gear did a test a while back (it also notes as to why Turbo engines are better suited to higher octane fuels)
Fifth Gear Fuel test
I'm sceptical about higher octane fuel in the Fazer - I tried 97 RON once but the bike didn't seem overly happy with it. However, I'm happy to give it a bit more of an extended try so for the next few fill-ups I'm going to try out Shells V-Power and see what happens - my engine can't get much worse

For those that are interested, Fifth Gear did a test a while back (it also notes as to why Turbo engines are better suited to higher octane fuels)

Fifth Gear Fuel test