Yeah, you need to activate the game on Steam, even if you’d buy the retail version.
The only ‘advantage’ is that you have a box and a CD. And I wouldn’t really be surprised if the CD wouldn’t actually contain any game files, seeing how Steam works lately.
