Like
@Nitr0 mentioned you can reject a lot of noise by setting up a noise gate and gain filter, which makes using a condenser microphone like the Yeti more than reasonable. The Yeti also has multiple pickup patterns which can help reject side/rear noise depending on the setting. If I was trying to place a mic 1m away in my current setup, I'd probably end up using one of my condenser mics (the Yeti is a solid pick) or a shotgun. With that distance, you'll probably want to look into controlling some of reflections in the room with acoustic foam or by hanging some heavy blankets. If the Yeti isn't for you, you could also consider the Blue Snowball, Audio-Technica AT2020, or Rode NT-USB microphones. All three are solidly performing USB condenser mics at alternative price points.
Most noise cancelling microphones are designed to be within inches of the mouth, not across the room. You'll see them more on headsets or boom mics like the BoomPro (which has passive noise reduction, not active cancelling) rather than on standalone microphones.
As overkill as it may be, I currently game with a Shure KSM8 mounted on a mic boom attached to my desk, suspended in a cheap shock mount, running into an XLR interface, USB to the computer, into whatever game I'm currently playing. The KSM8 isn't hyper sensitive, being a stage microphone, so it's suspended about 3-6 inches away from my face. That setup gives me the most noise rejection, so teammates hardly hear my typing, AC noise, room noise, etc.