It's always possible to use snow or rain in a level, but use an AS or a trigger which determines or allows a player to determine when it's precipitating and when there's no precipitation in the level. Because I also hate playing with extreme weather in the foreground, it's an eyesore. However, falling snowflakes typically look amazing. And rain or snow tiles like to be in tilesets just to give mapmakers some inspiration, since they just look wet that way, so can be used for other purposes. For example, SE, maybe you wouldn't want snow to look that way as it falls, but that could depict snow that's already fallen and stuck as a foreground element to go along with the never-melting ice on the ground.