Just by using a microphone away from the camera and closer to your subject things generally will sound much better. In that case almost any microphone should suffice to getting decent audio. The most popular microphones used by DSLR shooters are the Rode VideoMic and the Senheisser MKE-400.
The Senheisser MKE-400, priced at $199, is said to have slightly less audio quality than the Rode VideoMic, but is favored for it's tiny tiny compact size (unlike the Rode). If you're taking size into consideration, I've had my eye on this particular shotgun microphone from China that runs less than $40 dollars. It can go by the name EG1 or EC-330 and I've been waiting for someone to throw up some type of review or audio test to see if it's even worth the penny. After posting the article on the larger $35 dollar China Shotgun Microphone, one comment comes in reminding me about it. Yup, still not much information out there, but it does look like a good alternative if you want the compact size of the MKE-400, without having to spend the $199. Here's the link to find the cheap eBay EG1 shotgun microphone, so if anybody has any more information, please drop a line. If lack of information drags on further, I may have to purchase one to kill the curiousness.