There's no such thing as "the best" when it comes to gearing.
The transmission is there to get as much out of the engine as possible.
If your car got an engine with a wide powerband, you don't need that many gears to get the engine to work where you get the most average bhp from the engine to the wheels.
That would be a high volume engine, or an engine with a turbo/supercharger.
On the other hand, you have the F1 cars, or the high end NA engnines, seen in an M3 (343 bhp from a 3,2 liter enigne), or a Ferrari 458 (560 bhp from a 4,5 liter enigne). When power can't be produced at the lower rpm's (As in the turbo/big volume engines), you need rews to make the engine produce bhp's from the much lower tourqe.
This will make the powerband more pointy, and therefore you need to change gears more often to let the engine work where the most bhp's are produced.
You can see pointy powerbands in turbo cars as well, but this is generally speaking.
So there's no right answer to your question.
Then you, as an individual can prefere a sertain type of gears, and a sertain type of engine. I prefere the engines that produce the power from high revs rather than from a ton of tourqe at the lower revs.
A car that produce a lot of tourqe are in most cases the better option when it comes to service bills and reliability. I.e trucks/lorrys/huge machines are often powred by huge diesel engines with a lot of tourqe. Hence why many diesel cars can go very far for a low cost.
On the other hand, you got the race cars, and high reving enignes.
The maintenance bill is much higher, and the cars can't go near as long as the diesel one (again, in general). But I just love the high reving sound..
As a fun fact:
An F1 engine produce around 250-300 Nm of tourqe. And that's about the same as an ordinary family car. It's the engines ability to rev high that transform the low tourqe to a lot of Bhp's.
Revs*Tourqe=Power (Simple version)
A Truck engine produce around 2500-3000 Nm of tourqe. And that's about 10 times more than in an ordinary family car. It's the insane amount of tourqe that helps the engine to produce around 500 bhp, dispite to low rpm's it's using. Somewhere between 1000-2300 rpms.
This last "fun facts" section is not 100% related to the OP's question, but as a side note to what I tryed to explain, I think it says something, as long as my grammar allow you guys to understand what I'm on about. Sorry if it's not good enough..
