It really depends on how much sparkling water you drink. If you're having several glasses daily, it usually pays off financially. One CO2 cartridge roughly lasts for about 60 liters of water, depending on how much carbonation you like. The cartridges cost between 8 and 15 euros, so that's roughly 15-25 cents per liter. At the supermarket you often pay 30-50 cents per liter for sparkling water in plastic bottles, sometimes even more for better brands. The device itself costs between 60 and 150 euros upfront depending on the model, but you'll make that back with regular use within a few months.
What personally convinced me the most is just the convenience and not having to constantly lug around crates. The cartridges are tiny compared to water crates, and you can just swap them at the supermarket. These things are really reliable, some people have had theirs for years without major issues.
The only thing that's a bit annoying is the plastic waste from the cartridges themselves - but some of them actually get taken back and recycled depending on where you swap them. Compared to tons of plastic bottles, that's way less waste. If the environment and convenience matter to you and you drink sparkling water regularly, I'd say: yeah, it's worth it.