Well, I'm an office manager in a family business...not really a dream job, but a cushy job. I get to make my own hours and there are a lot of other perks, but it also comes with a lot of worry because I'm closer to my job than most people. Since it's family, their worries become my worries.
My dream job? Always wanted to be an archaeologist. I love old things, old cultures, old - anything. Digging through the dirt for hours to find a shard of pottery actually sounds like great fun to me. Alas, it's not for everyone, and I doubt the pay is very good.
If I really had to think about it, I think my true dream job would be anything, as long as it paid the bills and left a little extra to invest or play with, but also left me with enough time to enjoy my family. The family - that right there is your most important 'career'. Sometimes we work so hard to provide for our family we never actually get to spend time with them, and before long they're just strangers to us.
Another thing to take into consideration is that in today's world there really aren't careers anymore. The job you have in your 20s may be totally different from the one you have in your 30s, 40s, and 50s. The world is changing so fast there's no guarantee that what we train for will actually be what we're doing years later. My suggestion would be to look at those jobs that may still be here in 10 or 15 years. In the US there's three fields that I can think of that seem to guarantee some sort of employment - health care (including home health aides), computers (programming and repair), and service businesses, like electricians and refrigeration mechanics. So maybe the best thing to do is to investigate what sort of job opportunities there are in your part of the world, then do an honest evaluation of yourself to see if you may be suited for any of those jobs.
You also may want to ask yourself if you want to be an employee, or a boss. The latter comes with a lot more stress and headaches, but you also have more control. Also talk with your family, they may be able to see what you're best suited for better than you can yourself.
In the end I would suggest making some lists - it can help you make an honest evaluation of your situation. Firstly, write down the pros and cons of being an employee vs. being a boss. Secondly, make an honest assessment of how much time you want to devote to your family vs. to your job. Thirdly, the sort of jobs you may like or be well-suited for, and those that you know you would hate or be terrible at. Fourthly, the jobs that are available or expanding in your part of the world, and those that seem to be dying out. Fifthly, if it's appropriate in your situation sit down and talk openly and honestly with your wife (or significant other), sometimes getting another viewpoint from someone who really knows you can help.
das