Not sure about sodastream, but guess it will be same as a an S30 cylinder, in being filled with liquid CO2, not CO2 gas.
A gas fill, wouldn't get you far in pressurising anything else.
Normally, a CO2 cylinder, such as pub or welding one, with regulator, is designed that when upright, it...