No great game is enjoyed by everyone. Your options when making a work, of any kind, are to either A) make something utterly inoffensive to the point that no one will have strong opinions about it at all or B) make a game that some people will love and others will bounce off of.

Dwarf Fortress is solidly in category B. It's a sandbox game, which already selects for people capable of making their own fun with a toy, while alienating those who want more concrete goals. It's a simulation game, which selects for people who enjoy the thrill of experiencing something that nobody else has before, while alienating those who prefer a crafted narrative. And it's got a lot of fiddly little systems, that offer just a little bit of reward for mastering, which selects for people who like figuring stuff out, whether through experimentation, external resources, or a combination of both, and filters those who just want all their options presented to them in a streamlined experience.

If a player meets all those selection criteria, they'll likely find Dwarf Fortress one of the most fun games they've ever played. They'll marvel at all the intricate details, and invent explanations for things that are (probably) random, like imagining the master engraver who keeps carving masterwork depictions of that one time he single-handily defeated a forgotten beast all over the captain of the guards' bedroom as being petty as hell.

If a player gets filtered, then they'll bounce off the game, and because they haven't engaged with all its fiddly details, feel like the game is just boring.