I remember that scream when I was playing the good old pro evolution soccer series some years ago with my friends (what memorable tournaments I made!). Now a friend developer just released a nice game – ok is not 3d, but what matters is playability…! Here is the description, directly from his website:
Sensational Soccer is a classically styled football game giving you control the whole team. Compete in league or cup competitions. Play against a friend in the 2 player mode. Create your own match winning tactics. Playable with either Keyboard or Joystick or Mouse. Full player database featuring all the squads from over a 40 leagues worldwide with realistic player stats.

Try it, you might be surprised.