Download the Steam program from steampowered.com and look through through their shop integrated into the program, if it's on sale on Steam it's 'steam powered', meaning you can run it off the program without the DVD.
If you purchase a game from Steam or a game doesn't require a CD/DVD to run, then it will open directly from Steam. If not, you will need the CD/DVD in the drive.