First thing that's important is that say for instance the S65 and most other V8's have cross-plane cranks, versus the F1 and most other exotics have flat plane cranks, so that in itself affects the firing order.
Also, you have to consider the cylinder numbering can be different from brand to brand. For instance, GM has one bank be the "odd" cylinders, versus ford has one bank be 1-4 and the other be 5-8.. In other words, on a GM V8, the drivers side bank are cylinders 1,3,5,7 and the pass side is 2,4,6,8. On a ford, the drivers side bank is 1,2,3,4 and the pass side is 5,6,7,8.
The firing order has an affect on how smooth the engine operates, the important part is that one cylinder fires every 90°, so however you accomplish that is really all that matters.. The major benefit I could see is for exhaust scavenging.
Obviously exhaust scavenging isn't as important on a boosted engine versus a N/A engine, but in F1 even 5-10HP can make a big difference at that level of performance. For a street car, I don't think it matters.
1994 Infiniti Q45- First 5-speed swapped Q45.
2007 BMW M Coupe