I'm a new player, and dwarf stress spirals are the biggest thing keeping me from playing Fortress Mode. It feels awful to try and get started; from the moment I see my dwarves around their wagon I feel like I now have a vague but very real timer on how fast i have to get EVERYTHING done before my dwarves start becoming miserable due to things I can't control.
Rather than enjoy the game, if I embark I expect to have to spend a couple hours frantically trying to make sure I know EVERYTHING about Fortress mode so that I waste as little time as possible immediately doing everything I can do avoid stress, which I just simply cannot do. Even if nothing "bad" is happening, any random minor cause of stress will begin to pile up from the very first second while it feels like the few painfully obscure ways to reduce stress (a "mist-generator"? are you kidding me?) require so much micro-management while literally stress just pops up everywhere at all times.
Basically Fort Mode feels like if you inherited someone's farm, and then from the moment you got there, they told you that you had to provide for and take care of their seven children while the land is actually on fire somewhere already and you have no way to put it out. It's not fun. All of the fun bits of the game would be accessible AFTER I have reached a stable point, but currently this game seems designed to ensure that doesn't happen.
Let me get my thoughts in order. My issue as a new player is that immediately after embark, 1) stress begins to build immediately before any counters to it or ways to cope can even be planned, 2) the ways I can help dwarves deal with stress require enough time and resources to make that I can easily have many stress problems before those are even achievable, 3)sources of stress outnumber and outpower de-stressers even on top of being ridiculously inconvenient, elaborate, and tedious to the point of frustration
Dealing with stress IS the game right now, and it really doesn't feel like a rewarding or enjoyable one.
Not to mention, you know... Maybe I'm asking for something unreasonable, but like, combat? It's pretty cool? A huge amount of detail went into it and it produces some of the most dramatic and interesting moments in the game. I'd sure love to be able to focus on that, explore and play around-- oh look all my dwarves are suicidal now due to dead bodies and the horrors of wars. That entire culture of warriors and craftsmen in this world of incredible violence where multiple wars are waged 24/7 and many many many conflicts can LITERALLY only be solved by violence...
Once AGAIN this game punishes the player for doing things the way they are presented to them. "Losing Is Fun" if you can actually learn from the experience and do better next time, but... This game is so misleading, all the time. Purposefully obscuring what the impact of the player's actions are, or what the source of anything is (negative or positive). And right now, if you aren't playing Fortress Mode the exact right way (like say, having every possible source of Good Thoughts by year 3 for your dwarves, with no deaths, handling every siege perfectly) then your reward is having even less time with your fort before the effort you put in goes down the drain. Very very unrewarding of an experience, and the idea of that pushes me away.
You're basically building the game to push players towards doing as little as possible, because the ONLY way to avoid stress is to never be exposed to it, currently. Avoid fighting. Avoid the outdoors. Don't build anything experimental. Keep the caverns closed. Fill this checklist of needs for every dwarf. Don't bother anyone.
And it still doesn't work from what I can tell? This game truly feels like things only get worse right now, even outside of Fortress Mode. World gen, necromancers just taking over every world with more than 250 years of history (more than 125 even in my experience), adventurers all just becoming traumatized husks within two weeks, forts all become miserable insanity-filled hellholes. Is there so little POSITIVE programmed into this world? Is that why it feels like you have to reinvent the wheel every time you want to do one-tenth of what's required to keep dwarves sane for a period of time?
I wish I could give more specifics on what key mechanics are problem-causing, but I haven't been playing for very long, and this is me trying to convey how negative the experience can be for newer players due to the obscure stress system (and everything tangentially related to it being at least as obscure and punishing).