A headset mic is genuinely fine when...
You're primarily in voice chat with friends, not recording or streaming to an audience. Compression on platforms like Discord and most games flattens a lot of the quality difference anyway. If nobody has complained about how you sound, there's no urgent reason to upgrade.
A USB microphone is worth it when...
You're recording anything that gets published — streams, videos, podcasts — where audio quality is judged on its own, not just as a side channel to gameplay. It's also worth it if your headset mic picks up noticeable keyboard or mouse click noise, which most headset booms do since they sit close to the hands.
A second, less obvious trigger: if you frequently talk over game audio and people ask you to repeat yourself, a dedicated mic with better noise handling often fixes this without needing to touch in-game volume settings.
Placement matters more than price
A $40 USB microphone positioned correctly (roughly a fist's distance from your mouth, slightly off-axis to reduce plosives) will usually sound better than a $100 microphone sitting flat on the desk three feet away. If you're buying a microphone, budget for a mic arm too — it's not optional for good results, it's part of the same purchase.
Choosing a mic arm
A low-profile desk-clamp arm is enough for a compact USB microphone and keeps a small footprint. A full-motion boom arm makes more sense for a larger condenser microphone, or if you need to swing the mic out of the camera frame frequently — common for streamers who face the camera directly.