Excellent topic
I have played a lot of adventure games in the last 5 years and although there were many that I enjoyed these are the games I enjoyed the most.
Using Pagodas Online Database for games released in 2006 and on
http://www.pagodagamedatabase.com/years.php
Sherlock Holmes: The Awakened 2006
Scratches 2006
Anacapri: The Dream 2007
Rhem 3: The Secret Library 2007
Sherlock Holmes vs Arsene Lupin 2007
Perry Rhodan: Immortals of Terra 2008
The Lost Crown 2008
Overclocked: A History of Violence 2008
Rhiannon: Curse of the Four Branches 2008
Diabolik: The Original Sin (in adventure mode) 2009
Last Half of Darkness: Tomb of Zojir 2009
Memento Mori 2009
AlternativA 2010
Darkstar 2010
The Filmmaker 2010
Slip Space: The Burma Shave Analogy 2010
Baron Wittard: Nemesis of Ragnarok 2011
Blue Madonna: A Carol Reed Mystery 2011
Conspiracies II: Lethal Networks 2011