Neutron Star Kicks in Isolated and Binary Pulsars: Observational Constraints and Implications for Kick Mechanisms