I have lots of dwarf fruit trees. They rock!
You will have many of years enjoyment from dwarf fruit trees in your garden no matter how small. You can have them in the house as indoor fruit trees as well.
In NYC you can maximize the over winterability of your fruit trees by placing the containers up against the wall of your house. If you are in residence all winter (ie the heat is on) then the house will bleed heat through the wall to the tree.
If you do this you can espalier the tree on the wall which is super cool too.
many photos and inspiration at my blog The Dwarf Fruit Trees Blog