Going forwards, I think W4 Games--founded and run by Godot's top devs--is going to be a popular option. They're offering fully-console-approved middleware for Godot 4 that you can use to export your game for consoles: https://w4games.com/2023/08/06/w4-games-unveils-w4-consoles-a-practical-console-porting-solution-for-game-developers/
As for what it's like actually using Godot: I've found it to be a well-designed, consistent, easy-to-learn engine (CB is my 1st Godot project), and flexible/extensible. Creating new engine plugins to improve workflow or add file format support is dead easy.
Of course, nothing is perfect. There are bugs and performance issues, but these also exist in Unity so that's nothing new to you. What IS new is that Godot gives you the source code, so that you can debug and fix issues yourself. You're not dependent on your vendor's priorities!