Let's not pretend that the vast majority of CP2077's side quests are not that type of C&P'ed filler crap.
They are.
What is significant about CP2077 is how a dozen or so side quests are incredibly stellar, far outdoing even the main (non-expansion) story quest. They're incredibly good. That's just a few ones sadly, but they're big and have lots of interactions and cool moments though, they almost feel like the main quests in a lot of ways.
Ok its not loading properly on my phone so i accept i might have to eat my words here, but i remember the vast majority of quests in cyperpunk being "go into a building and kill some guys".... Not exactly ground breaking stuff
There are two tiers of side quests in cyberpunk. Gigs and full on side quests. The gigs are all pretty short ‘go to place, shoot / rescue someone’ stuff but the main side quests are generally more involved, including all the romance options etc.
The gigs can be skipped without missing much, but skipping the side quests misses a ton of story IMO.
That bit about "every designer or artist has a bunch of shit ideas and just picks their best 5%" is SO TRUE. Remember this when you're doing something creative and don't feel great about it. Just keep doing it.
I did some research on quest system design and found a Unity plugin that reduced them down to basically eight core tasks, which means you treat it like data entry. Just have the writers draft up the elements at each part of the timeline and fuck it. Have to think more holistically and probably do the writing first, tasks once you're happy with where to go.