My favorite '90s weather app was WetSock. The installer was 1.5MB, though I don't recall the RAM usage. It showed a sunny/cloudy/etc. icon in the system tray, with the temperature in a tooltip:

https://web.archive.org/web/20010210023051/http://www.softse...

https://web.archive.org/web/20070210195451/http://www.locutu...