I think both of SEO Ultimate and Yoast SEO are pretty good. And lots of their features are more or less alike except few differences, such as Yoast has XML sitemap generator and some other pluses. I found this article on the comparison.
I think you definitely need SEO plugin to succeed in search visibility. Its best to study SEO beyond plugins though, I would recommend this book: SEO – An hour a day. This will give you a basic knowledge of what SEO is and how to position it strategically on your website.