I've put in probably over a thousand hours on it, and have played it over the years as new releases come out. I've gotten to the point where I usually hit FPS death (too large a fortress that it overloads the CPU) even on the harder starts and with dfhack to help.
The draw for me was the steep learning curve that rewards you with logical complexity when you finally understand it. The lore that your fortress generates, as well as the random stories, is just icing on the cake. It's definitely not for everyone though since the UI requires additional programs like DF Therapist and DF Hack to be manageable still.