The funny bit is that aero rims help the pros in a road race in sprints and breakaways but riding in the peloton the wheel aerodynamics do very little. If you do most of your riding without a peloton dragging you along, you are getting a benefit the whole time.
Helps when I get dropped from the first group in gran fondos and have to take turns at the front of some ad hoc group of stragglers 😒
Anyway, I just don't see much of a downside to running a mid depth - let's say 45mm - CF wheel with 25mm tubeless tires. No issues in wind and plenty comfortable at reasonable pressures (that said, infrastructure is not a dirty word around here, and I keep at a reasonable cyclist weight).