It's been a few years since I've tried, but in the past I went through so many bulbs that whine when dimming that I gave up and put in smart bulbs where I can conceivably hear the bulb. Which means I've got switches that don't work properly if the hub is down.
I love the Caseta otherwise. We use it for recessed cans and the whine is just not quite noticeable. But, e.g. over my bed it's very noticeable. Maybe newer models of Caseta solved something and the bulbs aren't the solution?
The dimmable room that is working "best" is the one where everything is Hue and controlled "together" but it has issues when the Internet is down. The push-button switch they no longer make works decently well even then (sometimes): https://meethue.co/products/philips-hue-tap/
I'd add to your advice and say "do as much as you can to keep the experience vanilla," which in this case means standard fixtures and bulbs, just replacing the switches. For the price of half of one Hue bulb, my whole fixture is smart now, and I can still use whatever bulb I want.