So you start your post out saying most quests are enjoyable then spend the rest of your post explaining why the quests in this game are bad & boring (enough to even make you not bother completing them)Most quests are enjoyable in my opinion, in fact some gigs are funnier than main quests, especially the last mission, wow that was bad.
The reason, gigs to me are funnier is because they let you approach them as you want and with how you created your character.
I did some testing with the quest where that Arasaka guy have to speak with the sister during the parade and the whole build up, is that you have to hurry. So decided to take my time and just wait for 5-10 minutes real life just to test it, and it didn't fail. The only one I found to do that, is the one in the beginning and I tried to hide upstairs, instead of going behind the screen, but just got instant killed. The main quests are so extremely scripted, that if it weren't for the story part, they would be very boring the second time you do them, in my opinion.
Also your character mysteriously loses some of their net hacking abilities during boss fights and just get them replaced by some other ones?? It was not possible to balance these so they worked?
I didn't bother to complete the Cyberpsycho quest, as I after the first 6-7 already knew that these were just minor boss fights, put there for grinding, with what seem to be very little effort put into making them interesting.