Hockey players look like normal bigger than average guys, track guys are insanely fast but that's it, NFL guys are insanely strong and fast but closer to normal guys. Stand next to NBA players or watch them up close in person, they are not built anything like normal human beings.
It would kind of depend on how you define "freak"
I know PJF performance mentioned the other day that he thinks track and football guys are the best athletes. Less skill involved in a lot of the events/positions.
Track guys are probably in the top .0001% of their specific skill (ie. vertical for high jumpers, top-end speed for sprinters). Same with football players.
As far as pure SIZE or body shape and things like that, basketball players definitely top out.
I'd also put tennis players up with some of the best athletes in the world all-around. But I might be crazy.