I tried it in my car (Ford Escort) but it made no difference.
Some cars like it, some don't. My old Lexus felt no different running on "ASDA" or Optimax
The WRX though runs like shit on anything other than Optimax, even BP Ultimate runs crap compared to the Shell, but then my car is mapped for Opti.
The newer the car, the more likely it is to be able to take advantage of it.
A common misconception is that higher octane fuel = more power which isn't the case, the calorific value governs power and it's pretty similar between normal unleaded and super unleaded.
The advantage of higher octane fuel is its knock resistance allowing you to run higher cylinder temps and/or pressures with more ignition advance so you can either up the compression ratio, increase the boost or increase ignition advance or a combination of all 3. This is where the extra power comes from.
With a normally aspirated engine, the only change you can make during normal running is ignition advance (and you could probably run a little leaner, too), but only if the ECU has reasonable knock correction (which bike ECU's don't currently have).