Prime is the most basic (though, not by much) as far as amount of features, but offers an even sampling across the several different fields of 3D modeling (including animation, post production, and of course modeling). It's the best choice for less-than-professional/recreational/educational use.
Broadcast specializes in animation. It has everything Prime has, plus more features to facilitate the creation of animation and footage enhancement.
Visualize specializes in architecture, designers, and photographer-related work. Like Broadcast, it has everything Prime has, plus advanced features for lighting, environmental settings, textures, and rendering tools. It looks like it also has the functionality that Broadcast offers thrown into the mix as well.
Studio is all of the three previously mentioned versions wrapped into one, and is basically the best they have to offer. Whether that's because of the combined features, or because of other performance enhancements, I don't know.
To answer your question, they can ALL do what you might ever need it to do in your lifetime. All that's left is for you to decide how much you want to pay for the same program with a little more features than the previous version. Of course, let's be honest, you're probably pirating it anyway so might as well go straight for Studio