You'll probably find varying opinions, but if you don't care about noise Noctua makes some industrial fans that are quite popular with people that go in for extreme cooling.
If you are talking normal static pressure optimized fans. Noctua again has some decent ones, Phanteks, Sharkoon, Cougar just off the top of my head. You'll have to balance cost/appearance/stats to really make decision.
For intake fans that are relatively unhindered you don't need static pressure fans. Though most people tend to get a single fan type and stick with it across a build. SP fans still move air, and tend to do it fairly quietly compared to airflow fans.
I should add that Corsair makes better versions of the fans that their AIO coolers come with. Corsair SP120 are not terrible.