The long and the short of it

Came across this great thread while asking the questions myself.... What's the difference between short, medium, and long- cage rear derailleurs, and what length do I need? Long medium short?