Unfortunately, I don't think that Dwarf Fortress is a game that is enjoyable if you just look at someone else playing it. There's too much little stuff going on in the screen to figure out what the big stuff is and the pace of the game can be slow. There are a few good video tutorials, though.

Just try the game.

edit: there are some tools you can use to visualize your dungeons and what is going on there. There might be nice videos of some 3d-renderings of fortresses that might be nice to give you an idea of the game.