Blender is great, I also use it. It's a nice example on how a non-developer tool is successful with open source.
There are/were plenty of open source RPG makers, but they never gained any real traction.
I considered open sourcing my product in the past (did so with a previous game), so maybe one day. I still have some big things planned :).