I know a bit about this as I sometimes work for a company that prepares fuel stations for switching to Super Unleaded and then goes back to the stations about six months later and starts to sort out the problems with the tanks!
Firstly yep you will get more woomph

cos it is a different blend of fuel
Thats the good bit,
The blend contains a lot more Ethanol than normal petrol and whilst this is good for whoomph it is also much more hydroscopic and causes clotting , to a degree, of the fuel which can have an adverse effect on your injectors.
So if youare gonna run it then ensure you take the normal condensation prevention steps and you should be fine. better still run it from daytanks!
If memory serves me right Esso, Total, Jet, Texaco amd all the supermarkets all use fuel from Vopak terminals. So its all the same stuff so you can shop on price without worry about the quality.
of all the fuel companies Tesco by far has the best tank maintenance policy so their fuel is usually pretty good.
BP and Shell use propritry fuel