I've yet to really try the paranormal career but think I may next :)
Personally I like the work from home content. Juice Fizzing and selling them from the tables.... I did that this playthrough and I made 200,000 simoleons in one sitting. It's crazy broken lol.
My Sims always have a small garden with flowers, so flower arranging as well with Plopsy.
Painting and photography I'm actually doing now after Juice Fizzing, my Sim has a muse that he takes photos of and then creates paintings of the photos he takes (cause photos aren't worth much)
They are really OP when you get dragonfruit and orchids for Juice Fizzing, and Orchids for Flower Arranging but I like to explore and stuff more than sending my Sims to work. Get a few hundred thousands simoleons and then take vacations. I also noticed recently I can gift other Sims $$ and it actually goes into their household funds so I am making my friendly Sims rich lol.
Not really career specific but my favorite skills are fishing, gardening, photography, wellness (oh I actually like being a yoga instructor too), flower arranging, painting and knitting.