The first game that comes to mind and probably my favorite in this category is Portal.
Also, most games in the point and click advanture genre are non-combat games. I just reacently played Machinarium, which is an absolutely beautiful game artistically (and hard as hell without a walkthrough).