Football manager if you like tactics, but all the rest are just rubbish.
If you're looking for fun gameplay in a football game, unfortunately the best really was back in the PS2 days. Heck, even the best arcade football games were from back then.
If you insist on getting a new one, FIFA is definitely the better choice, but they've been getting progressively less fun as EA neglects improving game mechanics and single player game modes in favor of the Ultimate Team cashgrab. If you do want something more modern but not necessarily contemporary, the most fun I had with a football game in recent(ish) years was FIFA 15. There's still probably some mods for it to update the rosters and whatnot. Then again, I'm not even sure EA allows you to buy the game individually anymore. I've seen some older FIFA games available only through their subscription service (lol).