Yeah, Aero just got a bad rap when it was on those lowend desktops and laps when Vista came out.
Yeah it did though that being said I've got a friend who has a Dell Inspiron 530 which was released when Vista was still pretty new (Core 2 Duo, 2GB of RAM, integrated graphics) and it ran the Vista Aero UI perfectly well. It's running Windows 7 now (I upgraded it for him a couple of months ago) and that's running well too.