This sounds like a testimonial ad for Herbalife.
$50 consumer-grade products are almost always "crap," but you're making a sweeping generalization across dozens of product lines in 2 brands without offering any evidence or proof that you used appropriate products for the task. Fans on most UPSes only kick-in when their inverters run during an outage or a test for cooling.
I happen to have an SMX1500RM2UNC with humidity and dual temperature logging. It's floor or rack mountable, uses commodity batteries in a repairable pack, expandable, remotely manageable, logs details, works like a champ with under-voltage and other edge-case transfer conditions.
A writer is extremely unlikely to be an expert on backup power supplies anymore that I am an expert on coronary cannulas. Appeal to authority or an anecdotal testimonial is flimsy support, at best.
Sorry for your loss, but you might be wandering into the weeds on this one.