I've recently boxed and stored my desk microphone. I only do about 2-10% SSB, but I have changed over to a headset/microphone combo. Currently, I am using a cheap-O computer gaming headset I bought, along with the necessary adapter to fit my rig, from W2ENY. This works just fine for me. The headset is cheap, so I actually bought a spare Koss headset/mic, and with both headsets and the adapter, I probably have about $100 invested.
Microphones are like CW keys in that if you ask 'n' hams their opinion, you will definitely receive 'n+x' replies, where x is any number greater than zero. What works "best" for me, may not be very good for you. Or, it may not work at all. You can get answers to the "work at all?" question here on ling, but as to how it will sound with your rig and your voice characteristics, we can only guess.
Oh, and as someone else asked, what rig are you running? Different microphones may sound a bit different with different rigs.