its only beneficial if the car can take advantage of it, and if the car can take advantage of it, whether you will actually be able to tell the difference depends how sensitive you are.
Some cars (that are designed to take advantage of higher octane fuel) get improved MPG from it.
The instruction manual for my car says it performs best on 98ron fuel , so I try to use Vpower whenever I can, but on the odd occaison that I’ve had to use 95 ron, I have to say its not the massive difference a lot of people claim (maybe I’m just not sensitive enough?). This is on a fairly high performance 4litre v8 that should be generating 414bhp.
In summary – All current uk production cars will run perfectly well on 95ron, some may benefit from 98ron or higher , but in my experience the differences are marginal.