In that thread, I mentioned my own good luck (so far) with a HUSBZB-1 USB adapter which supports both Zigbee and Z-Wave, although I’ve only used Zigbee so far. I won’t repeat it all here, just wanted to be sure that option was mentioned.
Also check out this thread very informative, i have a zigbee2mqtt usb with antena and it works great with my Aqua, hue and tradfri devices, and the good thing about this usb is that it also works as a mesh system for your devices to link up too, and is the cheapest way to do this imo.
How was the Conbee 2? I am also looking to replace Hue & Tradfri hubs with native HA integration, everyone has very strong opinions on which is better it’s hard to make a choice which way to go!