Fix the camera and get the perspective right and that's entirely possible. 'Wacky' Day of the Tentacle type perspectives would be a little more difficult maybe.
But is Source capable of the complex processes required in an adventure game? Dialogue trees, an inventory of items that can be used together etc.? I really have no idea.