I have finally decided
Dwarf Fortress Adventure mode with DFHack ad-fort is the ultimate roguelike experience
You get the best of both worlds, the greatest sandbox basebuilding system with great roguelike mechanics, and the worldbuilding and lore generation in DF is genuinely the best