Seeing how so many people don't want any more rabbit holes careers and so many others do want them, I think as @stilljustme2 says the best is a middle ground. The careers in CL are a perfect combination. You can work from home (so common nowadays with most jobs allowing you home office every now and then) or go to the classic rabbit hole. For my gameplay style is very important to have more variety of rabbit hole careers since I usually play households with more than 1 sim in them and I like to focus on other things while some sims are at work. It is also important for the stories I want to play.
I also would love "dead-end" jobs and part-time jobs for YA+ as well as self-employment.
I think a pack that combines all of the above could work really well as a GP.