As someone who does this as a simple hobby to pass the time, I have no problem whatsoever with the RTP. The RTP certainly has it's charm. Right now, I'm working on a really simple project. It's short and sweet, and about 90% of the visuals is RTP. The only exception is the custom made portraits of RTP characters, and Holder's animated battlers. Oh, and the title screen, game over screen and window skin. But all the maps, character sprites, etc... all RTP. Mainly I use it due to consistency. If I went and used some custom sprites that I've found, I would then have to somehow get matching animated battlers, or scrap having animated battlers all together and stick with basic sprite-based battlers.
Personally, if I can get people to play and enjoy this game when I've finished it, without having to go scouring the net for all manner of custom resources, then I've accomplished something great. I'm not going to want to pay someone a lot of money for custom graphics to use in something that I'm going to eventually hand out for free. When I've finished the project, and if people really like it, THEN I would consider a visual overhaul and replace the RTP with custom tiles and sprites, etc.
As for crap games made with RTP... the same could be said for games using custom graphics. You could have someone be all "Oh my god check out all these amazing scripts and graphics for my game, it makes it the best!" but the game could be a steaming pile of crap because they weren't creative with the use of their resources and the story being really weak. On the other hand, someone could get really creative with using the RTP and Eventing and produce a far more superior game. If we're speaking about someone who has some really amazing visuals AND writes an amazing plot and comes up with some really fun game play elements, then of course it's going to be better than any RTP game. But I'm not so pretentious that I would rule out playing a game just because it was made with the RTP. Not everyone has the means of getting amazing resources for their game, yet they strive to make it shine in all the other aspects. I would be really insulted and upset if I put in a lot of effort making a game, doing everything I can to make a great story with strong characters and fun game play only for someone to snub me just because I used the RTP for the visuals. So I certainly wouldn't be doing that to someone else.