There are engines around to create (realtime rendered) 3D games, but they're not specifically designed for adventure games. You also have to know quite a bit about programming.
Examples:
Blender:
http://www.blender3d.com
DarkBasic:
http://www.darkbasic.com
Jamagic:
http://www.clickteam.com
--Erwin