Adventure mode is more like a 'standard' RPG-style adventure, similar to nethack but entirely generated. https://dwarffortresswiki.org/index.php/DF2014:Adventurer_mo...
It doesn't have as much polish as Fortress mode, but it can be quite fun if you like the nethack style of "die early, die awesome, die often".