One of my favorites (more for what it is rather than what it does) is the Title Screen glitch (or what I like to call the one button glitch) in Ocarina of Time.
If you press A at the last possible frame before the screen fades out when the camera enters the Lost Woods, you'll advance the game state from Title Screen mode to File Select mode, but the next cutscene in the sequence will play normally, but you'll be dumped at the File Select rather than return to the cutscene in Hyrule Field.
It almost has a use. It can be used as a back-up cutscene pointer for the Ganondoor Warp, but the Hyrule Field cutscene is about 1 min long and the trick is frame perfect.
WW BiT has an interesting story to it. The original Back in Time glitch for Windwaker was a trick discovered by Animeowzers that I believe skipped a dialog with Tetra, which in turn caused some goofy side effects. When I saw that video, I was all "that's not Back in Time" and in about 30 mins of attempts I managed to perform the older "reset in a void" BiT trick.
WW BiT is fun. I'm sure you've done EMS in TP, so do you not like that? It has a lot of subglitches, not to mention it's a major sequence break. I think all the BiT's are fun, hands down. It's gotten to the point where I'm beginning to wonder if Nintendo's intentionally putting them in now, especially considering how easy it is in SS, it's as though the testers HAD to find it. I hope BiT will never go away. I'm just waiting for the next console release to see if BiT exists in it, considering every console Zelda since the Wind Waker (except Four Swords Adventures) has BiT in it. I wonder if it will be in the upcoming Zelda for the Wii U? Let's just hope!