In the UK I fill the car up with 95 RON fuel (90% of time) from all proper fuel stations except supermarkets (exception is Tesco Momentum 99). Eg...I would fill at Shell, BP, Esso, JET, Texcaco. When the fuel prices are lower (which is very rarely these days) I might give it a tankful of Esso 97 or Shell/Momentum 99 RON fuel. Does it give more power? Maybe 2-3 bhp more, but I cannot feel it. Does it give more mpg? According to the fuel computer (my journeys are somewhat consistent) yes it does by 3-4 mpg, but once again, I did not compare with the amount of litres going into my car. Calculations between extra cost of higher RON fuel and more range per tank, still shows 95RON is still marginally more economical. Might be the car thinking (like humans), expensive 'higher quality' wine or champagne must be better, therefore yes...97/99 RONit gives more mpg. Only Esso 97 gives me a 'smoother/less stuttery' engine from low revs, this I can 100% confirm.
Had a flatmate who only filled with Supermarket diesel for a good 10k miles worth in a 1.5Dci Clio. Tank would last 9 days tops (she only does, to work and back)...persuaded her to use Shell Vpower Nitro Plus Diesel, she scoffed, protested, argued, she's not rich etc...but gave in anyway, cause I wouldn't shut up. 1st full tank of good stuff, lasted 10 days. 2nd tank of good stuff lasted 11 days. Calculations, was cheaper to run the good stuff, as it would give 60 miles more! So it depends, perhaps engine just got a nice clean from the good stuff...like descaling a kettle.