I'm from Queens, New York, and I speak with a Queens accent similar to Paul Simon or Woody Allen (without the whine, though LOL).
The NYC accent is pretty much dead in Manhattan south of 96th Street, especially among people younger than about 40 or so. It's alive and well on Lawn Guyland (Nassau and Suffolk counties on Long Island), though, even more than in Queens proper. It's also dying in the "hipster" sections of Brooklyn. Even on Long Island, it's modified in people under 45 or so. The distinctive Robert DeNiro-type prosody is less pronounced in younger people.
People from Upstate New York, outside of the Buffalo and Rochester areas, speak with a "General American accent." Same is true within the northern Midwest outside the major metropolitan areas--except for Minnesota and Wisconsin and adjacent areas, where the "Fargo" accent predominates. Milwaukee has its own accent.
In Buffalo, Rochester, Cleveland, Detroit, Chicago, and even Minneapolis, there's something called the "Northern Cities Shift." It's a very distinctive accent which is too comprehensive to describe here. It's a itty bitty bit like the New York City accent--though not that much.
New Orleans has its own accent, which sounds somewhat like the NYC accent in some respects.
Throughout most of the West, younger people speak with a "General American accent." Older people speak like cowboys, sometimes. There is a sort of "Valley Girl" accent in the LA area.
Even in places like Maryland, Delaware, West Virginia and DC, a southern accent is discernible, though it's more subtle than places further south.