Engines like Unity or Godot are also well suited for 2D games and don't have the problem you have described. Also, there are quite a few game genres between visual novels and AAA 3D games.

You are right that you can often ditch the engine, but you should only do that as an experienced programmer who can assess the scope of the project. AI doesn't really change that IMO.