Yes it's for real... Higher RON fuels will make your engine run cleaner.... but how much additional power and mileage DEPENDS on;
(i) how your cars engine is tuned
(ii) how you drive it.
EG: most unleaded petrol cars are tuned to run on 91RON fuel. The 3RB requires a minimum of 95RON. All recent model cars (ie: about last 10 years) with on-board computers and electronic fuel injection have their on-board computers programmed to learn from the engine's knock sensors... so a car that can quickly learn it's running a higher octane fuel (eg: 98RON) will quickly re-map the timing to exploit this. The result will be improved power and fuel economy, assuming you don't hammer it!
Generally speaking, performance 'oriented' cars will be more finely tuned to exploit the higher RON fuels.
I see a 1l to 2l/100km improvement in fuel economy by using 98RON over 95. The Lib learns pretty quickly.
My father has demonstrated the same improvement in his '02 supercharged Calais using 95RON (manufacturer recommends 95RON). My mate with a GXL Prado finds the same result over time with 95RON (manufacturer recommends 91RON)... but the Prado takes a couple of tanks to re-map.
Each of the fuel manufacturers comes to the same result (boosted RON) by different means. Some use aromatics... other use different methods (starting to test the limit of my memory on all this now). In the old days, we used Lead to boost octane ratings..... not so fashionable anymore! SUPER Leaded fuel used to be about the equivalent of 99RON fuel if my memory serves.

Going unleaded was a step backwards for performance/ efficiency... but a BIG improvement for your health!
I use Caltex Vortex 98 on every tank in the 3RB and regularly get average consumption of 10.5l to 11.5l/100km (70:30 City:Hwy ratio). That's not bad for a relatively thirsty flat six! Best ever achieved was 8.7l/100km (long trip, all Hwy). I like Caltex bacause it does the job and I can use my Woolies vouchers there.
People tend to have their favourites... I don't see any point getting all caught up in that. Suggest you experiment and find what represents the best value for you.
Cheers,
Deucer.
Ex MY05 3.0R-B Wagon... But Still in the Blood.