Hi, I'm a full time game developer. I saw this post on the main page and decided to give some insight.
>I am aware that I can't do all of that on my own, no developer creates their own art, their own music, does the coding and the writing.
I have no idea where you heard that, but it's false. You can absolutely do everything by yourself, the main issue with this is that it's never going to be as "high-quality" as someone who takes their time to focus in a single one of those things. That being said, even though it's not the ABSOLUTE BEST quality, you can still achieve some pretty good results, and the more you work on these skills the better you will get at them.
>What I ask myself is if it is possible to create a game without programing?
Apart from the RPG Makers out there, here are some tools that you can look into:
Construct 2 (or Construct 3): This is what I use daily to make games. The programming on it uses what we call "events", much as RPG maker, but you can make any type of game on it. It also has what they call "premade behaviors", which mean you can just add an image to your game, add a behavior to it (for instance, a platformer behavior), a solid ground and you can already move it around.
GB Studio: This is a lot like RPG Maker, but it makes games for the Gameboy/Gameboy Color. I cannot recommend it enough, especially for anyone getting into game development. Since graphics are only 4 colors and it only has small tiles, it's much MUCH easier to draw something here than any other tool. This is a great tool for learning simple pixel art and basic programming (since it also uses events).
GameMaker Studio 2: This one is a bit more advanced, but there are a ton of tutorials online, enough that you can get a simple game working no problem. It uses "GML", which is programming, but it's their own language. It also has what they call a "drag and drop" functionality that works somewhat like the events in Construct or RPG Maker, but I wouldn't advise using it - you'd rather learn actual GML since there's a lot more tutorials for it anyway. Post too long. Click here to view the full text.