If other cities were built to similar density, you could have a similar (or even better) energy footprint compared to a New Yorker without the necessity of having to live in NYC itself. Now, there would be a change in lifestyle (fewer people owning cars, more people walking and using transit, fewer people owning detached houses) but most of those benefit quality of life anyway.
Unless you are actively turning some non-productive land into productive land (eg, greening a desert), you're probably a negative on sequestration no matter what. It's just a question of how negative, and living in the city is probably less negative.
If anything taking sequestration into account would make suburbs look worse. 100 acres of dense urban development plus 400 acres of untouched forest is going to sequester much more carbon than 500 acres of suburbs with a few trees sprinkled throughout, yet they would hold the same number of people.