Allowing you to buy and download any of Valve's games, like the recent, fantastic Left 4 Dead 2, Steam also has a huge library of titles from other big developers, as well as free demos and videos. The list of games is ever increasing, and it also supports non-commercial things like game mods.
Installing and setting up a Steam account is really easy, and the download manager is very stable. Whatever your internet connection speed, you don't need to worry...
.