When I was following Synology communities closer, the common wisdom was that the expansion units weren’t great in either performance, stability or cost, and you were better off buying a new, bigger unit and then selling your old one used to recoup the cost difference.
I’m also in the same position, I have a DS918+ that is full. It’s also 6 years old and probably on the tail end of getting software updates so I’m weighing my choices…
There isn’t a standard that is broadly-adopted, but NUT (https://networkupstools.org/) has reverse-engineered drivers for nearly every UPS out there, usually each brand has their standard so as long as the brand is supported it will work. (NUT is also what TrueNAS, Synology, QNAP, etc use internally for their UPS support)
I’ve had good luck with using NUT with APC UPSes (both consumer models and buying used enterprise rack-mount models).
One cool thing you can do with NUT is share the UPS state over the network, so that multiple machines can respond to the power state instead of just the machine that is plugged in via USB directly.