Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Most people here will probably say Handbrake, which is free. It's the only one I've used, so I can't make comparative statements. It works very well. For some dvds you will need an accompanying decryption application. VLC is one such, also free.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.