The DLSS-FG without tearing is a bit of a PITA, to be sure. You're forced to disable VSYNC in game to enable FG, but IIRC you can re-enable it within the NVIDIA control panel to ensure it paces correctly with screen refresh and also doesn't tear. I really wish it wasn't such a kludgy affair.
As for buying it with Steam vs Windows store vs XBOX game pass, I guess it depends on whether you have an XBOX? Personally I don't play enough games to get my money's worth out of Gamepass; I simply don't have that kind of time. If/when I buy it (and I'm leaning hard on when) I'll certainly buy it on Steam.
I'm waiting to hear more "complaints" before I buy it, so far all I've seen is hilarity which I would've attributed to the typical Bethesda game "charm" of wonkiness we've all come to expect from their Creation engine. You know, wonky dialogue, sometimes strange animations and physics, bizarre character creation attributes, and game-breaking closed-loop items. At this point, most of that is just part of the game and I'd be at least a tiny bit disappointed if it were all fixed.