This!
I think the complaining about commute from Brooklyn/Queens to Willets is purely psychological. It's a long commute to Bronx or Willets, but psychologically it feels more frustrating because Willets seems nearer. Of course, when the stadium is built, I think that goes away too and it's just a commute.
As for the North of city crowd, it was already said for me:
For the most part I agree, one minor argument for the subway riders would be that the willets point location makes you dependent on a single train line with only the 7 going there, if anything goes wrong you've got issues where as the current bronx site has more lines allowing for a back up plan when the inevitable weekend construction work or unplanned issues happen.