Writer is pretty good once you have established yourself. You keep getting a steady trickle of royalties, work minimal hours, and if you want a bit of a top-up of cash, you can just pump out a couple of books.
As someone who has the Dine Out pack, I wish that you could hire your own Sims as the Chef in your restaurants. That would be interesting both from the perspective of that (the chef) Sim, and if you played a different Sim visiting the restaurant for something to eat.
I've only just bought the Paranormal, Dream Designer and Island living packs (build-a-bundle), so I haven't explored their relevant career paths yet.