Yeah, dragon fruit grow just fine here in Florida, but as Carol says, the fruit is interesting but not all that tasty. I would love to see a flower on the thing, though. They are beautiful, large and fragrant but bloom at night and only last one night, so it's hit or miss if you get to even see it bloom.
People up north grow them in greenhouses, and that seems like a good way to actually see the blooms at least. You could probably prune it to keep it from taking over if you had a greenhouse, or even a really sunny window. They are a little bit prickly, too of course, being an epicactus.
My dragon fruit plant is currently rambling along one corner of our stucco wall, but the oak tree near it has grown a branch over its location, so I'm not getting any flowers or fruit until I tackle the job of pruning the oak tree.