Is Unity good for adventure game development?

Hey game dev friends!
I’m considering building an adventure game with a story focus, with puzzles, choice-based dialogues, and some exploration. I have heard a lot about Unity’s flexibility, but I’m wondering – is Unity a decent option for adventure games? Or should I check out Godot, Unreal, or even specialized engines like Visionaire?
Would love to hear your experiences, pros & cons, and any tips to make adventure games easier with Unity!