@Sandfang
I haven't played the detective career, so I have no helpful tips directly related to that, and I'm not from EA so I will not address the frustration since it would not be productive for having your voice heard.... but...
In addition to the important suggestion from @jpkarlsen (pause is your friend many a time in Sims) I had a few things I though I'd share that helped in my game.
- I have played high-drain careers before and they can be rather discouraging, especially if once you reach the top tier of the career the drain is still strong. As far as quests, I have noticed that with my max level Scientist I completed the original tasks for the day and there kept being more added. I didn't remember seeing this at lower levels in this 'go to work with' career. But at the top level even though more tasks kept arising on the list, and not everything was done like at lower levels, I wondered if it increased the end of day pay, as she came home with a huge check for the day. I haven't tested that, but it may be possible. Maybe you should not worry about finishing every single task at work, then see if the day is less draining? If I don't enjoy the work type or workload for a particular career once you hit the top level, I find a new career. There are definitely many less stressful careers irl and in the game.
- I hate throwing birthday parties in Sims. Parties or social gatherings in general can be a chaotic, high-maintenance mess. I avoid them like the plague, and I know I'm not the only one.
- I almost always add a fenced in yard with a gate that's locked for dogs. I add a doggie door so they can use the yard and we're good. They can get into or out of the yard when they're on a leash or your sim is carrying them - or you can unlock it until they go in, etc. That is the safest way to avoid the run-away thing. There are also traits that will make running away and exploring more likely in cats and dogs. You may want to avoid those. (Also, the automatic feed dog dish does help some, though I still have to call them to eat some of the time, which is weird.)
- A frozen/stuck sim can be reset. (Unless you mean they are stuck behind something, etc., in which case please remove items or rebuild areas they they are routing into but cannot route out of.) If your sim freezes or has a coffee cup stuck in their hand or that type of thing, please leave then re-enter the lot or shift-click on them and choose to reset the sim.
It sounds like maybe you're on console? If so and shift-click won't work there, please reset the sim as in these instructions through the cheat bar: https://help.ea.com/en-us/help/the-sims/the-sims-4/how-to-reset-stuck-and-unresponsive-sims-in-the-sims-4/
I hope something here may help a bit.
SheriGR ☕ – I don’t work for EA.
Me Too – if you also have this problem – first post on thread has this button
XP – for helpful comments (& to help others 'level up')
Mark As Solution – to help others find the answer to the issue now & in the future