The 'fear of death' is applicable only when 'aging is turned on' or elderly as others have mentioned, isn't true for me. I've received this for two different YA sims. The first received it when aging was turned on and set to 'normal,' and the second received it when it was turned off for active households. (two different sims both times, and the second wasn't in the household until aging was turned off).
The unfulfilled dreams thing is easy to avoid if you do a few wants occasionally, but it's frequent enough that it can impede a storied-gameplay. Sometimes I don't want my sims friends with someone or to call someone or to keep listening to two to six different music stations. I've actually been telling my sims to dislike stations because having more than one music 'like' means you get a bunch of 'listen to ____' wants. The fact 'Listen to' only lets you select the currently played station makes this more frustrating. There shouldn't be a 3-click to accomplish this (change station to->[music genre], click stereo again, listen to->[playing music genre]), when a 2-click could work (click stereo->listen to [music genre]) it's bad UX.
Fear of dead-end job isn't easy to avoid. It occurs in situations and on a frequency that doesn't make any sense. Freelance careers should be exempt, as well as sims who have reached the 'max promotion' (I realize you can get raises, but you're already at the top. focus on something else - if this were real life, I'd switch companies but the sims only has 'one company'). Quitting doesn't seem to be a great option, especially if it goes against the story you have for your sims. Plus the issue of the 'wants and fears' not turning off, as other users have mentioned and I've commented on in other threads.
Additionally, I think all of this could be less annoying if the interactions weren't sometimes buried so deep that it made them difficult to find. Interactions relevant to wants and/or holidays, aspirations, or whatever currently relevant situation, should be the first thing in the pie menu. The fact wedding stories makes all the wedding interactions the first thing in the pie menu adds another layer of frustration to this broken system, in particular when you already have an officiant, etc., and they remain persistent.
I'm not sure what is up with the UX, but I dare say, give that team more funding/support to do their best job. This is what creates animosity between users and software. Bugs are bad, they can be fixed, but poorly implemented features kill. It just wastes developer time, your time, and our time.