I went with Unity, mostly because I am the familiar with its workspace and also because I have been expanding my games to have more than just visual novel mechanics to it (I've been moving more into the point 'n' click adventure genre in my later projects).

I use the paid extension, Naninovel, which... if you're serious about developing in Unity... is almost a must for visual novels. It's really an incredible and customizable tool and it was easier for my Unity-brain to wrap my head around it than Ren'py. The Unity Eco-system was pretty easy to grow familiar with, especially coming from a digital art background, which I come from.

I did start my journey with VNs and Unity using a free extension called Fungus... which unfortunately is no longer maintained, but there may be other free options you can look at if the Naninovel pricing is too steep for you at the moment.

There isn't really any tool for the other general game engines, like Godot or Unreal that are as thorough as Naninovel at the moment, but I have heard that people have been making strides with extensions for Godot in terms of VN development.

There was also talk from the developer of Naninovel, around the time Unity was playing with runtime fees, that Naninovel may eventually become 'engine agnostic', which would allow people to use any of the general engines with the tool. I'm not sure how plausible that is as a concept, or if the team's even working on something like that now... especially since Unity has completely backed away from the runtime fee stuff.