There are thousands of them, you can find lists of them all over the place if you do some googling.
One of my favorites, in Shadow of the Colossus if you dive into a tiny puddle, you can cause the game to completely crash. But only on the console itself, doing so PCSX2 will just teleport you in the air instead of crashing.
Link's Awakening you can softlock the game if you buy two shovels during one of the trade quests, since you can't throw away items and you only have enough item spaces for all the items needed in the game.
In the OG Grim Fandango with it's original release, there are parts of the games that can run too fast if your CPU is too fast, in some cases causing the game to freak out and stop at certain places. A patch released to fix this one though.
Mario Kart DS you can force the game to crash by holding down A and B on one of the sets of stairs in the Luigi's Mansion course, if you start turning the game will crash randomly. If you do it while online, and someone sees you do it, you can crash anyone's game
In BattleTanx, one of my favorite N64 games, if you use the infinite health cheat, sometimes you can't deactivate it which can cause an infinite loop in a bonus level.