what's the most recent book or movie that you saw that you really liked? With the right approach you can make anything into a game I'm legit making a game about cupcakes lol.
Besides that, I would say old fairy tales or folk legends might be a good place to look. they tend to be short and with a fairly simple storyline that people enjoy seeing reimagined, giving you room for your own creativity. The typical setting of these stories work well with the default art assets of RPG maker as well.
what kind of games do you like making? that might help narrow down what kind of stories you might want to look at.
I'm starting to wonder if I should go the Half Minute Hero route with my game. The character's main weapon is logistically way too strong. So I can't really let the player continuously grow it.... But if they had to build it up each time like HMH, that could work. Also it lets me take advantage of my randomly generated maps so much more. Hmm... This could work!