A W5 error usually points to a hardware issue, especially if the VIN
voltage is at 0. You might want to check the C-wire connection Unlocking
Success or try a factory reset. If it’s the second failure, it could be
worth contacting Google Support for ...
I understand your frustration. Have you tried reaching out to Google
Nest support through their social media channels or
halloweensquishmallows Sometimes that can expedite the process.