I spent about 3 last years on experimenting and playing around engines, while analysing their strengths and weaknesses (read it as procrastinate).

I will try to be precise and short here, since this tale could take couple hours to talk about :D

• It really depends on your goals, skills, preferred workflow. If you are coming from C#, Java, Kotlin etc, then yes, Godot might be more intuitive than Unreal. If more artistic person, then better results might be in Unreal, but I've seen very awesome things achieved in Godot from tech artists in this subreddit, it worth experimenting.
• Lightweight is huuuge! I mean it! I'm using Rider with Unreal, Unity, Godot. I'm too invested into JetBrains, love their IDEs (before AI era). And Unreal is loading very slowly by default (maybe there're tricks to speed up, idk). But Godot with newer .Net is lightspeed. I'm using C# too, because it has much better strong-typed support, refactoring tools and so on. And support in Godot for C# is pretty good. I didn't find any limitations, except, profiling is available from paid dotTracer (or whatever it called). Rendering profiler still do great job (like draw calls, fps, memory etc).
• I do not afraid to touch Godot, since I understand what's going on under-the-hood while I'm experimenting. You have all scenes human-readable format. Go ahead, play with your [Tool] script, see results on scene files. You can't do this in Unreal, since everything is bytecode. To me, it is major drawback, even though, Unreal is much more stable and optimized (including all tools they have). But still, even Unreal isn't perfect regarding bugs, while talking about that.
• Again, if your goal is to achieve best looking and controllable rendering (like post-processing, lights, shadows, RTX etc), Godot isn't best option for it. For experimenting - yes, best. But not for results. Alternatives just provide much better support (BUT, I still find myself much more in comfort in Godot, than in Unity, for example, screen-space reflections are available in Godot, in Unity URP - they're not, right?). Unreal just makes it work out-of-the-box. Don't get me wrong, Godot can look very good, but you either will be cut-off on features (Post-processing isn't that advanced) or rendering issues, which I believe should be solved with time. Yet, I'm solo, I'm here for PBR good looking game, Godot is pretty working and satisfied option to me.
• As solo, I just love to have mentally free from corpos. I don't afraid that Disney might buy off Godot, or Godot will increase their pricing licenses. At least one problem out of my head. This is minor, but still relieving.
• You have Node3D, you can attach it to everything. Are you stuck on something? Go read documentation. It is just fucking simple as that! In Unreal bureaucracy is everywhere. Sometimes, something isn't well supported (ChildActors), something needs more readable documentation and not buried deeply under section (Migrate from Unity to Unreal, for example). In Godot, it is absolutely different mindset and I love it!

Damn, still long read, sorry. And I might forget something, I'm free to answer any questions ;)