It's not only about steam. Like you said, the visual effect could be used for thruster trails, airlock pressurization simulation, internal pressure valves to give "life" to pipes, fire suppression systems, futuristic shower systems, giving life to vehicle launch "catapults", and more.