If you don't mind noise and want quality construction, Delta AFB series fans are some serious fans for higher speeds and built with industrial quality. They also have really good noise level per rpm but they don't do very well at slow speeds. 25mm fans rule the 500-1800rpm area when industrial 38mm fans rule higher speeds. Speed is everything when it comes to bottom line performance. Running 3000rpm Deltas could afford you upwards of 5x the radiator performance vs using 1000rpm fans. GT AP-29a do pretty well also and can go slower better than the deltas.
3000 is usually too loud for most users though where something in the 1300-1800RPM range is generally more accepted as ok. In the 1800RPM range the gentle typhoon AP-15 is a popular one also built with dual ball bearings and more industrial in quality. Some have however found their tone to be annoying and they do have their little harmonic issues at certain rpms. Noise blocker, Zalman, Helix and several other brands make good fans in the 1000-1800 rpm range too with perhaps better noise quality than the GT but not quite up to the same build quality or low noise level. In the 600-1400 rpm range there are many very good options and Swiftech helix, Artic cooling F12, noise blocker, etc. GTs are ok but their bearing noise starts to show a bit are very slow speeds. I am even happy with yate loon slow speeds down this slow. Gets hard to separate them at slower speeds most 25mm fans rated for lower speed do very well and much the same down there.
Depends on how much noise you want to live with and no there is not a one size fits all. Good high speed fans generally do poor at very slow speeds etc. Visual appeal, PWM capability, and accessories also a big factor to consider perhaps more so than performance details.