I do hate this question. Let’s start with there is no ‘best’ there is ‘best for you’
Yes I know - that’s as useful as Yoda saying “do or do not there is no try…”
For some Zwave is rock solid and stable. Those folks will say ZWave is best.
For some it’s horrid and they can’t get it to work for them or they say they’re ‘too expensive’
For some, Zigbee is amazing and fast and local.
For others it’s slow and they can’t get devices to stop dropping off the network because they live in an area saturated with 2.4Ghz wifi signals. (This is me BTW)
For some they SWEAR by ESP32 devices on Wifi.
Others have older Wifi gear and they saturate their network quickly.
This is of course before we start with Matter coming down the pipe - sometime…
So what I mean by all of this… THer eis no ‘best’ in all cases. You probably have a combination of issues which make one or more of the major network technologies work or not work for you… The only REAL way to know is to install some things in your environment and find out. There’s nothing wrong with mixing device types.
For your dongles - stick with the recommended hardware for your chosen integrations (ZHA, Zigbee2Mqtt, ZwaveJA and ZWaveJSUI all have recommended coordinator hardware lists) Personally, I avoid the Conbeee II (Older and not well supported in ZHA/Zigbee2MQTT) and any ‘combo’ devices like the Nortek. (Problematic if you use the ZHA migrate function later)
Again, you’ll get as many recommendations here as users. What is your objective -are you running HA only? How is your Linux experience? For me HAOS on a Rpi 4B8GB running on an SSD is my personal solution - but Rpis are as hard to find for a reasonable price as a Unicorn at the moment. You’ll also hear Nuc’s and Odroids mentioned. Whatever you pick, make sure it’s from a good vendor, runs Debian, and you see other folks having success on the forum with your chosen device.
You already know the answer to this asking it on a HA forum… But I will add ehre it’s less about is HA good (Yes, it is) for you it’s more relevant to be asking about installation method - core, docker, supervised or HAOS. Your answer will be a function of your answers to my questions above. (How experienced with Linux are you and do you intend to use the box for stuff besides HA)