Eastern Prickly Pear (opuntia humifosa)
This is the only native cactus to the northeast that we know of. It is extremely cold hardy (-20f) and tolerates our humidity very well.
Prickly pears thrive on dry soils (we grow ours in a tub of sand). They produce edible pads, known as nopales in Mexico where they are a common vegetable. They also make brilliant red flowers that give way to red fruits called prickly pears. They are tasty sweet fruits that can be eaten fresh or dried.
We sell unrooted pads of prickly pear. They don't look like much during the dormant season, just a shriveled looking pad of cactus. Plant the pad a few inches deep in a well drained medium and they will root without fail and grow vigorously.