Virtually every Sierra game can work under the latest version of Windows. Check out the Sierra Help Pages first at http://www.sierrahelp.com to check for updates, patches, or other modifications to make your games work.
Also be sure to check out ‘Good Old Games’ where you can buy old Sierra games for anywhere from $2.99 – 9.99 each (and sometimes, a collection of games for under $10). These games are exactly the same as you remember them except they have been modified to run under Windows XP/Vista/7. Right now many Sierra games are on sale, too. Check out http://www.gog.com/en/catalogue#all_genres/search/sierra/