Hi Max
This is Tamal trying to answer your question.
From you description it seems like the Microphone or its cable itself was bad from the beginning. As the Red-light glows that means the Microphone is receiving power from the USB socket, but as there is no communication with PC then it could be the mic/cable partially broken or both. The easiest thing is to test with changing the cable, may be if you have some working one available for testing (like one with USB scanners). If that doesn't work, be sure it's the Microphone. May be take it to some electronics hobbyist & ask them to experiment & if they can bring any good news.
If you discovered the mic to be not working in the new condition, you should have claimed warranty in the first place or sale returned at the point of purchase. Your computer specs are good for gaming.