The effects are only noticeable when playing a challenge where every moodlet counts. Sims getting a little tense from doing things they dislike and filling their fun from doing things they enjoy isn't even noticeable in normal gameplay in a normal (even starter) house.
When you only have raw fish and the only sim who knows the nigiri recipe hates cooking, then getting her going requires a few extra steps. In the end that drawback added a slightchallenge (her teammates had to heap compliments on her), but nothing game changing.
Another time I had a sim who hated climbing, but had to participate in a mountain excursion for story reasons. His fun was was tanked, but he made it all the way up thanks to being very focused. Another sim, who was neutral towards climbing, died.