I know a few people who had seriously old bangers, barely staying on the road, ( pre-NCT) who found that the higher quality petrol was a good idea - car always started, less cutting out etc, but found no difference with a more recent car that worked properly.
I would say in the majority of cases, it makes no difference.