A) Perceptual (fast, similar inputs result in similar hashes - by design)
B) Checksum (fast, hash collisions from different inputs should be expected - by chance)
C) Cryptographic (slow, similar inputs results in very different hashes - by design)
Many security vulnerabilities involving hash functions come from using A or B when C should have been used. More subtle vulnerabilities come from not using a cryptographically strong algorithm for C (eg SHA1, and more recently SHA2), or not appending a unique and random "salt" to every input of C - so when your database is compromised attackers can pre-compute hashes for common passwords (if the attacker also has access to the secret key supplied to the hash function).
As the OP notes, these are fairly well known hazards which are easy to find more information on. I enjoyed reading about the more nuanced scenarios brought up by OP since they aren't as commonly discussed.