NFSFan's ROM is really good. It is the best for my needs at the moment, and it has the weather on the Titanium home screen:
http://forum.xda-developers.com/showthread.php?t=516509
EnergyROM is very good too. It felt a little slower for me, but that ROM is very polished (You'll have to install the weather thing on your own though).