The longest legit tags I've seen are explorers-of-time/sky/darkness and pokemon-mystery-dungeon.
The others are basically gimmicks. I remember this-is-a-question-asked-by-the-pika and absol-just-made-an-awesome-question and i-hope-you-like-this-question AND you-better-like-this-question. Need I say more?