This is a bit old now, but has a good break down of stuff that’s missing for large games. Godot 4 works well for smaller 3D games just fine, it just doesn’t do stuff like level streaming. Also it’s missing a landscape tool. (Though there is a third party one, not sure if it was ported to Godot 4 yet or not)

https://godotengine.org/article/whats-missing-in-godot-for-aaa/