Sorry mate. We are a bit scattered here when it comes to documentation & tutorials. There's bits & bats all over the place.
The only thing that is going to come close is Glenfx guide page, but be warned that it was created during the early versions of Visionaire Studio 3.x so it's a bit outdated & not everything works in the methods described in his guide.
The door thing, like many other things are mostly condition based. In case of needing a key to open it, you would need an inventory system that the player can store the key in. You would then query on the door with a item used or dropped "key" (depending on how you setup your item interactions) to trigger some actions, one will most likely be the changing of a condition you've linked to the object & called something along the lines of "door_locked".
You will have to be more specific about close-up puzzles as no one on here has really covered them. There's just the odd few examples (mostly puzzles that require Lua script), such as sliding puzzle, combination lock, etc.
Thank you. I found the GlenFX tutorials and they help a lot. I've been investigating conditions and inventories, but it's very sparse as you said. Does anyone have any basic example files that has some simple set up? ie: a few scenes, a character, doors, inventory and objects? That seems to be an ideal way to start.