The SFP+ ports on my 150w PoE switch are only 1Gb. The MikroTik CRS305 switch is the most cost effective one I’ve found at ~$130. UniFi has an option but it’s $599.
DAC is the most sensible option considering I need to go from my basement, up 2 more stories to my attic, and drop into my office.
True that. Between the weird "phone home" stuff that Ubiquiti just stopped responding to publicly and some of the odd overlap with their product line. That being said if you own their stock today you were smiling because they're up over 30% at the time of this writing.
With regard to USG the Dream Machine looks to be a kind-of-sort-of successor to the really old USG. I would guess a USG replacement is coming, but the Dream Machine Pro will have 10Gb as I understand it. They do product rollouts pretty horribly IMO.
DAC is the most sensible option considering I need to go from my basement, up 2 more stories to my attic, and drop into my office.