You won't be able to use Cumulus 1 with the new versions of what you are considering. They changed the protocol to support new things and Cumulus 1 stopped being developed. But move to Cumulus MX or other software (Meteobridge, Weather-Display, WeeWx) and you are back in business.
So there are still ways to run PC software via network connectivity. With the station brands you are looking at the easiest and most powerful way is to add the GW1000.
Older weather stations were not smart. There was no WiFi or Ethernet for devices or hardly anything but a laptop, smartphone or printer had direct network connectivity. Now with the IoT (Internet of Things) everything is smart and connected directly to the Internet without a computer. So naturally weather stations are too.
So what do you loose with an IoT weather station? Nothing. You gain reliability of being easily connected and not needing to run a computer just to put your data on the Internet. You can still view the data on the Internet, you just use a browser and go to weatherlink.com (for Davis), Ambientweather.net (for Ambient), Ecowitt.net (for Ecowitt), myAcurite (for Acurite). And you can go to Weather Underground for all of them. You could argue that you loose PC software analysis and having local data backup.
But you can still run PC software also, just requires the right newer software and perhaps some add on hardware. You can even run software on something that is a computer but doesn't look like a traditional computer (a Raspberry Pi). Or you can run a dedicated device like a Meteobridge.
Now you can free up your computer to do other things without needing to run weather software and without missing out on data every time your computer freezes up or needs a reboot, or it decides to update in the middle of the night.
To answer your last question, yes a GW1000 would work with any current Fine Offset clone.... BUT... the frequency has to match. There are three frequencies: 433, 868, 915 and depending on country the frequencies are restricted. If for example you get a 433 MHz Misol then you need a 433 MHz GW1000. You can't change the frequency, as it comes that way from the factory.
Unfortunately not all Fine Offset clones being sold today are current models. They still sell some prior generation models. Thankfully it is easy to spot the difference between new and older generations because they look totally different.