Ahaha, that happens to all of us! The trick is to plan out your whole game from start to end, the storyline, game play, everything! You may not know how to reach the next step, but at the very least, you know what you're doing! You can always ask for help on this forum, I feel that everyone here is 100% reliable. There can be many reasons as to why one can feel like canceling such as stress, lack of time, scripts pissing you off,boredom, etc. As long as you know the reason as to why you feel like stopping a project, you can always think of a way to counter it. The way I see it, you originally planned to make this kick-ass game and stuff. Everyone has a plan like that, but then, you realise that it's too difficult. All you need to do is just practise. Play around with RMXP/VX a little. You can always ask for help in the forum if you meet a hiccup. Read tutorials, stuff like that. I know the feeling of not knowing what to do and eventually giving up. If you're just getting the hang of it, keep it simple! Don't expect yourself to create a world-class game within just a few weeks. It takes time and effort to make a good game.
I'm not sure if any of my tips will help you, but I sure hope you cure yourself from 'The canceling cycle'