While not as suitable for actually playing tile based RPGs, I am partial to http://orteil.dashnet.org/experiments/dungeongenerator/ for the nice visual design of the generated dungeons.