Am personally fond of the Shattered Pixel Dungeon approach, where most of the map is procgen, but several key quests/areas/boss-battle-arenas are handmade.