While not the most downloaded plugin, WordPress SEO is the one with the most momentum. Many webmasters swear by it. Personally, I've seen good results, and I particularly like the Google snippet feature, which allows you to see how Google will display your page as a search result - handy for writing those meta descriptions!
Bottom line: Yoost's plugin has played a positive role in the rankings of my site. Recommended.