I had a soda stream, used it a few times, wound up trashing it. The problem is that A. all their syrups have half sugar, half artificial sweetener for some reason, which makes them taste awful, and B. the process is just badly designed. You have to carbonate the water first, then unscrew the lid, add syrup, then shake. In my experience, this generally led to the soda going flat pretty fast.
I suppose it’s good if you just want to be able to make plain soda water, but after buying the system, bottles, and CO2 canisters, it’s probably not much cheaper than just buying bottles of club soda when you need it.