Wow! A newer member with low post count who knows something! I'd love to discuss this over a pint or three.
Indeed, while a good case is important, the sound signature and level of components including fans makes the most difference. Grills are also a contributing factor.
I'm using an Evolv ATX and like it a lot. I am experimenting with spacing the front out 6-10mm to improve intake airflow area in hopes it will lower temps, and it does help, but not as much as I had hoped. Basically it shows the stock venting is not as bad as it looks. I am getting 3-6c better temps with the spacing.
Enthoo Pro & Enthoo Luxe cases are good. If silence is really important, the Define R5 is probably a little better, but it's fans would need to be changed.
I look at little things, like being able to clean filters without moving case from where it lives ( usually with it's back toward a wall .. and often under a desk). Bpth Enthoo Pro and Enthoo Luxe have 2x bottom filters, but taping them together with a few mm between them makes them into a single filter that slides out the front , same as Define R5. Evolv requires moving case out to pull filter out the back.
That is only a short list of cases I know are very good at reasonable prices. There are more I can suggest, like Define R4, Arc Midi, Enthoo Primo (much bigger), etc.
Like you my experiences with CLCs have not been good. Between marginal quality, loud fans and not uncommon pump failures making it necessary to have a backup cooler handy I avoid them like the plague I believe they are.
Good air cooling systems for CPU are common, and there are some quiet GPUs too, just not as well designed. While tower CPU coolers draw cool air from front and expel heated air back toward rear vent, I know of no quiet GPU coolers using this simple concept of intake and exhaust separation. Instead they all dump their heated exhaust every direct into all areas of case. But we can overcome most of these problems with cases that have venting over their entire back area, like one listed.
I can't remember how many posts you need before you can setup your 'trust' (1st button, bottom right) and be able to send me private messages.