How's the Detective Career?

OP, this is my experience because when I played that career I played it several times with several different Sims over several years. It's an interesting thing, especially if you don't spend all your time grinding and just doing the tasks you have to do. These were the bugs that existed after some patches back in 2017, and some still exist today. But I no longer play so you can look out for these things.

Let it be said when the pack was first introduced these bugs were not present.
But once CL was added due to situational outfits the game put on Sims even your own there arose a lot of problems.

1. Sims at the jail may not spawn. These were non playable and were there for you to fill some tasks like frisk prisoners etc. They also started just walking off so that task (can't remember what it's called) or fingerprinting etc. could not be done etc. At the first of this pack the game counted these characters as Sims so they counted against the head count of how many for population count. Just like the game counted dummies in the stores as Sims. But they increased the population counts so they shouldn't be a problem anymore.

2. Due to CL Sims who were the actual suspect were no longer dressing in the clues that were given. This became a huge problem and game breaking since the player couldn't fill the task to arrest the right Sim. It was still present about a year ago since random situational outfits still happen I would assume.

3. There was a problem with going back to work only to find out employees were ghosts and or replaced by ghosts (GT) pack

4. There was a problem about the chief remaining the chief so it was a problem to get the promotion, I don't know if they ever fixed it.

5. Lots where you went to get/ find the clues did not clean up (reset) after they had spots and other stuff left on them. You could see this stuff from the distances etc.

If you can't book the suspect I would call that game breaking. These things happened several times after the packs of CL, GT, Seasons and many others. The detective career became one of the most buggy things about TS4. I know I spent three years begging for fixes. Whether it's actually fixed or not will have to be proved to me. Note these were not all the bugs after they started adding more packs and patches.

But it was interesting and you had lots of time to play other things while at work. Hope they fixed it for those who gave them a zillion chances and seven years to fix it after they kept breaking it.

Something I thought of only after my detective retired... if you have suspects on the lot who match the description but are wearing hot or cold or situational outfits, introduce yourself and try using the "Ask to see outfit" social to make them change into everyday.
The workaround I found at the time was to keep track of which sims fit everything except the outfit clues, go back to the station without making an arrest, and put out another APB. If only one of those sims showed up on the second lot also, that was my suspect.
That was the only bug I had but I last played it in early 2019.

I don't think I enjoyed the detective in the Sims 4 and didn't finish it. The scientist career was good though.

I liked the detective career in the Sims 3! I played in 'roaring heights' Great Gatsby 1940s world, where I had a 1940s fixer upper that I fixed up and played the detective it was awesome. I think it works with an open world as you drive to different locations looking for clues in story missions.

https://res.cloudinary.com/lmn/image/upload/fl_lossy,q_80/f_auto/v1/gameskinny/025865171b2e01f5baa92ea462959031.jpg
https://www.carls-sims-3-guide.com/screenshots/investigator/intro.jpg

That is one career I have not played just for the simple fact that it was reported as being buggy. Beside, I was having a great time playing the scientist career. The doctor career was fun to play with coolspears mods but now, not so much. Buggy mess.

First time I played it I had no issues and actually enjoyed it. I even interrogated the wrong suspect a couple of times, I didn't feel like it was overly obvious. Repetitive, sure, but well, I sort of had a story and used my imagination to keep it interesting. Second and third times I tried playing it yeah, I had a few bugs. Haven't really played it since. I'm not sure how it's doing these days.

I don't think the Detective Career is that bad. I haven't played it all the way through yet but I do enjoy it. It is still a little buggy. Like sometimes its hard to catch the bad guy because you don't really see an exact description of them in said neighborhood. Or like the last time I played it, for some reason one of the other police workers were putting the police people in jail instead of the criminals but they were still able to go home at the end of the day and once she returned back to work the next day everything was fixed. It's annoying but I still try to just ignore it and just go with it.