In my experience, they got big by successfully partnering with Ironman - around 2013-14, they started leading Kona shoe counts. Suddenly everyone went from ridiculing "moonshoes" to actually wearing them as daily trainers and oftentimes racers too.
Nike had their chance when they came out with Vaporflys in 2018 and had every big time marathoner destroy decade old records but the tech they had (foam and carbon plates) quickly got commoditized.
TP-Link Deco line is reasonable. Fairly devoid of advanced features but plenty for probably 95% of the households out there - ie an easy VLAN separation into primary/IoT/guest networks, parental controls, QoS, meshing, etc.
Linksys should be immediately reflashed to run DD-WRT.
I had the same experience - everything runs great on an AWS Linux EC2 with 32GB of memory, same workload in a docker on ECS with 32GB allocated gets an OOM.
But for smaller workloads, DuckDB is fantastic... however, there's a certain point when Spark or Snowflake start to make more sense.
I own a host of Unifi hardware, but some of it is ridiculously vulnerable to power outages. UDM SE got bricked when I was moving and absentmindedly unplugged it without shutting it down first. Ubiquiti replaced it but cmon...
Every large database vendor forbids public disclosure of benchmark results these days - ie Snowflake, you name it. Privately it's a different story obviously.
