For your situation, I’ve seen enough cheap units fry hardware over the years to know your caution is TOTALLY valid. To give you a solid recommendation...
Seconding the recommendation above. NGL, the be quiet! unit is solid, but if you're seriously worried about those transient spikes with dual 4090s, sa...