Their moto is "Simple enough for a child: Powerful enough for a developer"
The RPG Maker's are very user friendly. Though the advanced scripting aspect of the newer ones requires some programming knowledge to make use of, but it is not required for the more basic stuff.
There are several versions, XP, VX, and VX Ace.
VX Ace also has a "lite" version which only has limited functionality, but is free. All (non-Lite) versions have a 30 day free trial though, and the trial gives you temporary access to ALL functionality until it expires.
Full version prices range from $29.99 USD to $69.99 USD.
http://www.RPGMakerweb.com The site has forums with community-made resources and tutorials as well. NOT ALL resources are free though, that is up to the person who made them.
There is also one called "IGMaker" which is far LESS user friendly but allows many game types such as action games like "Legend of Zelda".