Just in case you haven't seen it, I maintain this thread for
DTS Headphone X here. I recommend trying the trials for both DTS and Atmos and picking which one works best for your ears/headphones. To me, DTS Headphone X is the absolute clear winner in terms of audio quality and spatial awareness, but results vary.
But yes, I do think that spatial audio is a technology worth buying into. I've heard that the support on xbox is a bit buggy, but it doesn't only apply to games in the list. It also applies to any game with a 5.1/7.1 surround mix (almost all games these days). It works well and is an improvement over plain stereo in most cases, though it obviously won't have the height and other more nuanced elements of properly supported spatial audio.