This is a myth that's popular with podcasters. If you get as close to a condenser mic as you must with a less-sensitive dynamic mic* and crank down the gain accordingly, you'll find that condenser mics don't magically capture more ambient noise than than dynamic mics.
* Using a fist as a measure, your mouth should be between 1-2 fists away from the mic.
With a good preprocessor (I use a Symetrix I got from an old radio station), I can crank my dynamic mic (EV RE320) to levels that will pick up anything happening in my entire house, with my office door closed.
It's just that the levels from condenser mics tend to be hotter, so by default you hear more stuff in the room unless you get in close and turn it down.
There's no way to replicate the 'radio' sound if you're 2 or 3 ft away from the mic.
It's actively bad for most people for one reason: capacitive mics pick up everything.
If your room isn't soundproofed, it will be very hard to keep noise out of your recording. Dynamic mics are much less sensitive in this regard.
I would instead recommend a Samson 2Qu or Audio Technica ATR2100-USB on the low end ($70-100) or the Shure MV7 ($250) on the high end for plug-n-play mics.
If you want to move into a cheap audio interface (eg, Focusrite Scarlett Solo + cloudlifter), I'd recommend either the Shure SM7b or the ElectroVoice re20 on the higher end and the Shure sm57 on the cheaper end (good enough for the president to use for the last 40-ish years).