> big bottles lose fizz every time you open them
Solved if you use Fizz-keeper pump caps. This helps put the bottle back up to pressure after it's been opened so that the water doesn't go flat doing the same job.
We used to use these ~30 years ago when we had a Sodastream (I still have memories of going to John Lewis to get refilled cartridges).
Dalton's law of partial pressures says Fizz-keepers don't actually work[1].
6-packs of sparkling water bottles make our SodaStream look much cheaper than the analysis in the article. The SodaStream device itself was reasonably cheap too, I don't remember how much, but no more than 40 GBP. Overpriced for the simple mechanism it is, but kept our hands clean.
We do not generally use the SodaStream flavours. They're almost all horrible. The cola tastes like cola-flavoured penny sweets, and of course to achieve the concentrations required they need to use artificial sweeteners even for non-diet versions. They're all too sweet. The one product they sell that's any good - MyWater, and specifically the lemon-lime essence bottle in the three-pack - has been out of stock for the past 6 months in the UK.
We use the sparkling water for the things that we used to use store-bought for - watering down fruit juices, which are almost invariably 10% sugar in the UK from grape or apple juice filler, and for use with other commercially bought fruit and fruit squash concentrates.