The My Cloud is a network attached storage device, not a external USB hard drive. You cannot connect the My Cloud to a computer using the My Cloud USB port. The My Cloud USB port is for attaching external USB hard drives to expand the My Cloud storage and to use as a backup location for the My Cloud Dashboard backup feature.
If one has a second generation v2.x single bay My Cloud a red front LED can indicate no connection with a router. In certain rare cases a broadband provider’s router may cause an issue with the My Cloud. The workaround is to put a network switch between the My Cloud and network router. WD Support has a Knowledgebase article on this specific issue.
If the My Cloud internal hard drive has gone bad one could remove the drive from the My Cloud enclosure and attach it to a Linux PC, or a Windows/Mac PC (third party Linux driver may be needed) and attempt to recover the user data or unbrick a corrupted drive.