IMHO RPGMaker makes for a good entry into this stuff, because it's not super-involved like Unity or Godot is, but still allows some freedom to do some neat stuff if you bang it with a wrench enough times. It's really incredible the things you can get RPGMaker to do with the right plugins.
Best of luck with your game! Like I said, just take it slow, chop it into chunks, and as you get one chunk working, build on that and move on to the next.