Being realistic is most important. It is not the same as being negative but accepting that there are some limits to what you can achieve, due to available resources or your own limits.

There is too much unrealistic “positive” thinking, which taken to extremes can trigger off or even exacerbate mental illness when people go for unrealistic goals and have no chance of achieving them (I saw this happen to a lot of friends and it was why they often got addicted to drugs).

As for work even enjoyable jobs have boring bits and many of the “dream jobs” (if you mean making a living wage from creative stuff) have been eliminated by the same technology that creates this site and our radio station and all our gadgets.

I am lucky that my last two jobs have actually been quite enjoyable and even the one before was nearly a dream job (was being paid to be a broadcast engineer albeit for an outsourced company rather than in a studio) though it turned into a bit of a nightmare for the reasons mentioned above and I ended up back in offices and IT/Finance work and tech support. At the same time I work for a small family run business rather than a big corporate and am respected there and recently got back into the broadcast industry again (albeit as a volunteer), so good things seem to happen eventually if you are prepared to wait for them and are prepared to help others.