USB microphones are among the most prevalent for gaming and streaming fare, but you'll sometimes see the more widely used professional connection standard, XLR, make its way into high-end units. Hybrid USB/XLR can offer you the best of both worlds but tend to be more expensive.
USB is the simpler of the two, and if you're looking for plug-and-play ease, then it's your best bet. However, that simplicity comes at a cost. It's difficult to record more than one USB microphone simultaneously, and monitoring and adjusting the mix will be done digitally.
With the added complexity of XLR comes a great deal of flexibility that you otherwise wouldn't be able to access without even more complex digital mixing software on a USB mic. You can mix, adjust, and monitor an XLR mic before it ever touches your PC, and that's a massive boon if you're looking for a more complex setup.
The downside to XLR is that they will require additional equipment to connect to your PC. It is nothing wild, just something to interface between the mic and PC, such as the many devices by that name, which often comes with mixing functionality built-in.