I have been asking the same question, as part of evaluating a possible TR Pro or Epyc workstation build. The only cooler I’ve found that seems to be specced for this scenario (with front to back airflow) is Supermicro’s SNK-P0064AP4. However it has a scary 3800rpm/92cm fan and a 38dBA rating, so I’m not sure how quiet it would be. See also this thread at StH, with some mixed impressions.
The problem was discussed a bit also in this thread, though mostly w.r.t. slightly cooler Epyc cpus. Most of that discussion seemed to settle on accepting the down-to-up airflow (though again, the discussion there revolved around somewhat less powerhungry processors). We also discussed changing the airflow direction of Noctua’s NH-U9-SP3, but it did not seem viable in the end.
If I do a build on one of these sockets, I’m considering trying the supermicro cooler while waiting for Noctua/beQuiet/et al. to come up with something. But I haven’t tried it, and I don’t know whether it would be a better solution than a larger cooler in the “wrong” direction, as @CybeastRaystriker suggests.