Note: As of 2017, the maximum character limit has been increased to 35. This discussion has been left in its original state for historical purposes.
You don't have to go exotic and pull games like
"Do-Don-Pachi Dai-Fukkatsu" (25) or "むかしむかしあるところにとてつもなく仲の悪いツインテールの姉妹姫様がいらっしゃいましたとさ" (9001); even more common games like "Need for Speed: Most Wanted" (30) or "Spider-man: Shattered Dimensions" (26) just do not fit in 24 25 (thanks!) characters.
When you consider that this is practically the only form of tagging in practice for common questions, the limit becomes really painful.
Moreover, tag length is already different in SE 2.0 sites than it is in Trilogy sites (25 characters there, 24 here).
Can we, pretty please, increase the tag length limit to 30 characters? It will not fix all games, but then again no value does.