It might be the players on the pitch who create the sporting drama, but it's the fans in the stands who provide the atmosphere