Spot on - his hamming it up wasn’t annoying like some other actors, there was something quite special about it. As Cameron says, he was a kind of pressure ‘release’ in Aliens; his change from a cocky frat boy into someone absolutely terrified and then back to the ultimate badass is wonderful.
Also, I don’t think his role in Predator 2 is getting enough recognition, he was great in that.