I might pay the karma tax on this one but I've come to really appreciate "Times New Roman" (or TeX Gyre Termes + STIXTwoMath).
Like the OP, I used to care a lot about fonts. Heck, at some point my Windows boot time got slowed down because of the sheer number of fonts it had to load!
I used to think the default Latex font gives off a "serious" and "scientific" vibe. And I thought to myself: why would anyone ever use TNR when more "soulful" fonts exist?
Now that I'm older (33), I resort back to TNR or TeX Gyre Termes but with one change: I add "FakeBold" to text to make it look like old papers and books: https://x.com/OrganicGPT/status/1920202649481236745/photo/1. I just want my text to convey my thoughts, and I don't want any fancy "serifness" get in the way (so no to Bembo and Palatinno).