I don't know much about the 500X but I've heard good things about it. I don't believe the DCT is an option though.
I have a 2018 NC750X with the DCT and I'm thrilled with it. The low center of gravity makes it feel lighter than it is, so it's an easy bike to ride with confidence. I do mostly back road type of stuff but finally got it kitted out to do some long trips. (panniers, new seat, freeway pegs, heated grips, etc). My only "long trip" was about 700 miles and I was very pleased with it, can't wait to start piling on the miles. I watched a YouTube vlog the other day and this guy has a 2015 DCT with 160,000 kilometers on it. Most of his riding is all around Cambodia, Thailand, Vietnam and around there. He says it's been brilliant. Very reliable, the DCT has been flawless. (I have 2,400 miles on mine, so I have some catching up to do. Don't hold your breath...)
I have no experience off road with it but enough people on the forum do and with the right tires, it seems to be okay on the tamer stuff. It's not intended to be that bike, but if most of your riding is back roads and freeways, you'll love the NC. And the DCT. And the frunk!
I think most people will agree that it's good at just about everything. Not excellent, but really good. It's a very popular bike in Europe so there's a lot of aftermarket accessories available too, and it's a Honda, so it's about as reliable as it gets.
Good luck with your decision, and if you get the NC, report back with your thoughts and experiences.