www.themoviedb.org is pretty damn good and powers a lot of the homebrew media center solutions.

Edit: If it is critical to your app, you might want to consider licencing IMDB http://www.imdb.com/licensing/