I was lucky enough to attend two FIFA 2010 soccer World Cup games; I tried using my Nikon 18-200mm VR lens, which is a great lens but nowhere near close enough. I did also use a Sigma 10-20mm wide angle lens for some reasonable stadia and scenery shots, but what I really wanted were some close ups of the players (as more than just humanoid shapes), and some of the on-field action.
I've decided that the newly updated Sigma 50-500mm optically stabilised lens will be a good purchase; combined with a pair of Nikon 12x50 Action EX binoculars, I should be ok :-)