I am having exactly the same problem and cannot suss it out at all. Happened yesterday. Been using the WD 1TB Passport on MacBook Pro for 4 years no problem. Also using it on new Mac Pro for 6 weeks now, no problem. And then yesterday saving a CAD file got the spinning colour wheel of death and that was it, WD Passport no longer talking to Mac Pro. Tried it on the MacBook Pro and the same problem. Hooked it up to my PC and it works fine. Like you it doesn’t show up in Disk Utility either and when plugged into either Mac the green light on it just flashes and the disk whirrs as though it’s trying to find the file table or something, but failing. Anyway I have managed to back up all the data via the PC to my WD Cloud drive. Next step will try reformatting it and see if it then works on the Macs again.