@Blackcloud
I think there's always light at the end of the tunnel, it's just that we get lost in the darkness and we can't see it any more. So try to think of it like that... it's there... you just have to find it again and then you'll know which way to head off in. I know for me, sometimes i just need someone to help me find that light again. So keep reaching out and know you're not alone.
I know you're probably over the whole thing right now, so i'll completely understand if you stop reading here. But with the Windows on Mac thing, the Windows ISO file is available for free... www.microsoft.com/en-au/software-download/windows10 you just need to pay for the code to activate it. But it will run fine without activation. The only way would be a virtual machine. I would assume, even on a Mac, that getting a Windows VM running should be a lot more straight forward than Ubuntu. You have an M2 chip based Mac, not the older Intel based ones so the only way you're running Windows is through virtualization.
You should be able to return the hard drive as you said you were told it would do what you wanted it to do, which was wrong. Not the fault of the drive, but the wrong information you were given by the salesperson.
You should be able to find an older 2nd hand windows PC or laptop for next to nothing if you look around.