Steady on. I will not be put in the wrong.
Michael's original post said: "I am wondering [...] whether the pixel-shift technology of the A7R3 may give me the color (most important to me) and the enhanced resolution (however that works), so that [...] I might (at least for a time) be happy with what I have (or will soon have with the A7R3)?"
How is that a practical question? This is a man asking us to predict his state of mind when he owns a camera that will not be on sale for a month and that for the feature he is fixated on requires software that as of now is at "pre-beta" (https://www.sonyalpharumors.com/sony-also-announced-new-imaging-edge-software-suite/). But we can't have any theoretical discussion or talk about how it might be this or it might be that?!
He went on: "I am sure some of you here will have more technical thoughts about this conundrum I am in, either agreeing with me or pointing out something I have not thought of."
That is, straightforwardly, an invitation to discuss technical issues. It is not OK to whine and snarl because the invitation was taken up.
+1
The irony is, this is a Nikon forum, and Nikon doesn't have pixel shift, so how many here are going to be well-experienced in its usage?
Till now (as far as I am aware) only Pentax carried the technology ...
Even more ironic, Michael has used the technology, and is the very "person with experience" (in precisely his own style of shooting) ... and therefore
has the answers to his own questions.
The only remaining questions are, "What will the pixel-shift tech of the Sony AR7rIII be like, and will it render better color than the Nikon D850?" Michael already owns and is happy with.
Since no one owns the Sony yet, how can anyone provide an in-depth, practical response?
Theoretical discussion is the only option, other than not to respond at all.
If we attempt to discuss theory, perhaps a re-read of Bjørn's suggestion,
Also worth keeping in mind is the Law of Diminishing Returns, is the most relevant.
How many photos must we take, stack/shift, and combine ... with how many different camera/lens combinations ... before we can be happy with what we do?
Certainly, Michael has produced some exquisitely-rendered images ... so is the Sony pixel-shift/stack + adapter really going to make a difference over a D850 stack?
I honestly doubt it; in fact, already the D850 has shown to have better Base ISO DR.
At some point, it pays just to be happy, rather than forever chasing a rainbow of perfection ... that can never be caught.