It wouldn't be impossible, but depends on how the engine work.
For example, when it comes to game developing in general, making it snow or rain across a whole map would mean the game is rendering more activity than it needs to, especially if you're not going to see it.
But, a common game developing trick, is making the weather active exclusively around the games camera, under a radius of half a kilometre or so, give or take the draw-distance of the camera. It gives the illusion of active weather when really it's a 500m-size invisible bubble around the camera where the weather is actively happening. But by the camera's perspective it looks like it's raining and snowing in general.
Sonic Adventure 2 didn't have any stages with rain or snow, but Sonic Adventure had Icecap Zone, so wouldn't be impossible to import asset and snow effect over.
I know many games have snow raining, but I never see mods to make it exist for the game that's originally doesn't have that feature.
Or may be I just haven't met one?
Do Christmas mods usually have snow raining?