Cut should work best on leather or light armor.
Pierce and blunt should be best for tincans or heavy armor.
But in reality pierce is super efficient against everything while blunt can suck at times against low armored opponents (you think you'll kill them from one hit and that sometimes don't happen). Pierce is godlike and good against everything.
Pierce weapons are bodkin arrow, pikes, bec, xbows, lances... basically everything that seems OP to you and that kills you in no time is pierce weapon