
Shure
SM58
Indestructible live workhorse; but muffled for studio vocals.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
I use the truthear reds IEMs for Valorant and a Yeti Nano mic. I’m sure you can get a cheaper mic if needed but the IEMs are great for their price imo. Other commenters are right, you’ll get better advice from a different subreddit as your question has little to do with Valorant.
Brother, you’re comparing a $100 USB mic to a $300 XLR mic. The Rode is better, if you need a straight answer, but honestly, the Blue Yeti will still do a solid job. Also, I’m not sure where you are as a streamer. If you’re just starting out, don’t overspend. A lot of people drop a ton of money on gear before their stream earns anything, then end up selling it all a few months later. Start with what you have and upgrade only when it makes sense. Just my two cents from someone who streamed for five years as their main source of income.
Blue yeti nano. I have this mic and I am slightly biased. but a great mic. find it on sale and itll be easily sub $100
I currently use a blue yeti nano. The mic used to be pretty good (6/10) but I think I may have damaged it or dropped it on its side and now it's not very good (4.5/10) Because of this I've been looking into a new mic. I'm pretty broke so I won't be buying the mic I actually want, the Shure SM7dB (8/10)... But through my research and listening to video of people testing mics... I'm personally going to buy one of these two Fifine mics. The model I think I want more is the k688 (USB 7.5/10, XLR 8/10). If that's not available I'm going to go for the AM8 (USB 7.5/10, XLR 7.8/10). I'm pretty sure the fifine mics are both under $150... Good luck in your search!
Buy a standalone mic like blue yeti or hyper x or something along those lines.
I have used blue snowball ice for 4 years, now jumped on logitech blue yeti, no problems, clean sound :)

Shure
SM58
Indestructible live workhorse; but muffled for studio vocals.

Shure
SM57-LC
Versatile for instruments; needs pop filter for vocals.

DJI
Mic 2
Unbeatable convenience, 32-bit float; but poor Bluetooth audio.

Samson Technologies
Q2U USB/XLR Dynamic Microphone with Accessories
Great value dual USB/XLR; recent price increase noted.

Shure
SM7B Vocal Dynamic Microphone
Professional vocal sound; but expensive, needs external amplifier.