Check this link out if you doubt it!
http://fifthgear.five.tv/jsp/5gmain.jsp?lnk=601&featureid=143&pageid=273
take a look at this, shows that there is not neccessarily any noticeable difference in something like a 1.4 but in something designed to be more sporty then you can see the benefits.
Personally i always used tesco's fuel and occassionally tried bpultimate or optimax and never really noticed any improvment.
When there was the thing about super market fuels in the news i decided to try v-power regularly and i have noticed loads of difference.(i think its cos your ecu learns)
it costs me about £2 difference a tank and i was getting a return of 26mpg where as now i am getting 34mpg and i had my best of 36mpg.
i won't be going back to standard.