Horrible cooling is the last couple of years of Intel MacBooks. Nothing to do with Linux.
If you run them with a “balanced profil” in Linux, they run a bit slower but the fan stays quiet. It is probably what macOS does.
Before 2019 or so, they run awesome. I mean, the newer ones are faster so they run great too even in balanced. I guess it depends what you pay for them.
The older ones are crazy cheap these days and, in my view, great value.