CD Projekt RED confirmed that you may fulfill your Ghost in the Shell fantasy of becoming a cyberninja like Major in Cyberpunk 2077. Also, quests have ‘fail states’, meaning that you can fail their objectives and the outcome will have consequences for the story.
The developers also discussed balancing the ‘smart aim’ weapons.
Source: N4G PC CDPR: You Can Be Like Ghost in the Shell's Major in Cyberpunk 2077; Quests Have Fail States