Another one worthy of mention is Front Office Football 7 & 8, they are really good football sims, you should check them out if you care primarily about the franchise building and management aspects, rather than fast paced fun from FIFA, 2K and Madden, where the management aspect is much more shallow.
Depends on what you consider "best" in general, there is so many different talents involved in being a good football player. Tom Brady is probably the guy with the most accolades, but he is probably not even be the best quarterback. Overall, if we are talking RIGHT NOW, then probably Lamar Jackson, because he is not just a really solid quarterback, but he's hell of an athlete and smart. Mahomes is up there too, but really there is so many different ones to choose from.