Depends, you can buy quite expensive oil that will give "slightly " better performance it's personal choice any oil of the right spec should be fine, unless you drivec the life out of the car then even budget oil will be OK, I've never had an issue with say ECP triple qx brand which is usually cheap, over the last 22 years in our car, the important thing is change it every year regardless with the filter, rev the guts out of the car on a regular basis then change every 6 months.
If however its a twin air engine oil spec is extremely important