I've used Beautiful Widgets ever since I got my droid. The only thing that drives me nuts is the little big of lag I get sometimes when I wake my phone up and that widget is the last one to load up. I don't use a task killer either. Other than that I love it. I have heard good thing about weather widgets donate though too so I may try that out.
As far as real weather widgets that let you see radar, extended forcasts, etc. I've currently got both Palmary and WB elite on my droid. I like the layout of Palmary alot, and my only real complaint other than not having a widget is that I wish there was a way to turn off the airports view and maybe put a button to view the Radar up there instead. I don't fly too much so having the airports as such a prominent view doesn't benefit me very often.
I like WB Elite, the overall layout and functionality is nice, plus it integrates using google maps so when you see the radar and satellite animations it's pretty cool to see it with maps.