Greg, I'm sure you're generally doing a good job - but that's the problem - you're only offering generic advice.
And you falsely presume I didn't pursue many of these actions in your links before posting my question to the community. It is especially apparent when I stated the a Dell Tech Support attempted remote diagnostics for hours and also failed to resolve the problem.
In your genreic approach you failed to address a primary issue of the Device Manager not recognizing the adapter. So I searched the web and found this How to Easily Fix Missing Display Adapters in Device Manager video which manually adds the driver. However, it fails with my unit indicating the adapter is inoperable due to error code 31. Then, nothing I've tried has resolved this error and the adapter is still not connecting via the Cast button nor the App.
Lastly, you also fail to address the fact that it's hot to the touch at the HDMI end, So hot in fact that if I continued to hold it I'd get a first degree burn.
Then suggesting I pursue a warranty claim when a brand new device that has never worked is not appropriate, especially if repair success is only 70-80%. Returning it as a defective product is the only reasonable approach.
I can understand that you may take all this personally but the reality is Microsoft's trial and error troubleshooting approach is abhorrent. I hope you'll consider this as constructive advice to improve the responsiveness to issues Microsoft's customers face, like this one.
Sincerely, a VERY dissatisfied customer.