I dont think that KDE is actually lightweight KDE and GNOME are probably the heavy weight champions among the window managers on Linux. LXDE, E17 and others have a much smaller footprint.