Never liked the extra long Resurrection style fingers.
Yeah, they really amplified the "goofy rubber suit" effect.
Artistically I like the original giger hands. The knuckles always looked like little skull designs to me until I saw them really up close.
The most effectively used hands on screen would probably be the Winston/warrior hands. That shot in Aliens when the warrior grabs the APC door is well executed. Feels like the alien actually has a solid grip. Also the hand that goes around Hudson's face, evoking the face hugger to come.
The extra long digits do give a noodle effect.