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...
What are you even talking about? Garmin has an auto start/stop feature for lap swimming. All you need to do is single press top right button once to start the session and press the same button to stop and then another button to save it. It will literally do everything else for you automatically.