Sadly, you need to put in a lot of work to get good results out of it (neither of its predecessors had a reputation for being easy to work with) and for whatever reason many studios aren't exactly rushing to invest a bunch of time into it (many just go for Unreal Engine 5, or stick with Unity etc., indies often opt for Godot), so you don't get much past simple example projects. Part of this is probably that it never generated a lot of hype or much of a community around it.
Godot has a big community around it and is maturing pretty quickly, the early versions were pretty rough when it came to 3D (2.X and 3.X), but it's better now. Not as stable as Unity or Unreal but those have had the advantage of lots of years of work put into them, by more people than Godot has up until now.
There's also more niche options like Stride (https://www.stride3d.net/) and Flax (https://flaxengine.com/) but they suffer from the same issues as O3DE, even if otherwise are promising.
My guess is the primary use for this is going to be corps cloning it for their own internal use, whatever that might be. I see lots of huawei-aligned commits.
My general impression from lurking on these kinds of threads (with no relevant personal experience) was that Godot is a good 2D engine but not a good 3D engine. Do you find it comparable to the other two?