Stellar Counter-Rotation Along the Hubble Sequence: A Probe For Galaxy Formation Scenarios