I looked into point and click adventure game development some time ago. I was thinking about making an open source one, but I was kinda discouraged because of the replay value of adventure games. The problem is, you have to put online a finished game, or you wouldn't get patient users to watch your project while it's developing. Because these kinda games are heavy on story.
And pathfinding is a bitch to program. I know this is a Godot forum, but I will suggest looking at Adventure Game Studio. I know some people who made games with it alone.
And, good luck.
Edit: I've found some other good engines for adventure games too. I don't remember them right now, but some googling might point you in the right direction. Most of them have great communities around adventure game development.
It is totally possible in Godot, but why would you do that? It's not as easy to program as it seems.