Never tried Google Sidebar, but I have been using Yahoo Widget engine since the Konfabulator days. Like Sentinel said, it depends on the individual Widget and how many Widgets you have open at a time.
I usually have the Weather Widget, clock, CPU monitor and RAM usage Widgets on, and they barely use about 45 MB when loaded.