I can see your point, though I can see writers point to frustrate the player too. My only beef with Sinnerman is that there's certain continuity issue posted about that in
Continuity issues (1.3) and some follow up from
here.
There's a way to both frustrate the player and offer satisfying conclusion.
Good example of this is the Peralez Quest line ending, where you get to talk to Johnny and ask his opinion who's behind it all, him just giving his theory on what's going on.
Same thing with the Conspiracy Garry quest line where you go to the secret meeting site and Johnny asks "who do you think is behind this all" and you can say "Spanish Inquisition", Johnny replying "I didn't expect that."
That's genuinely funny, and even when you return back to see Garry gone, there's this
inner monologue with Johnny.
I mean it's good that not every quest ends up with talking 5 dialogues with Johnny but there should be something to soak in what had happened, getting an unique item to remind you that you completed that mission, even if you could never sell that. Some kind of memorabilia or progress toward something.
How about new equipment like Necklace and (as I may have already suggested earlier) have option to have V's own necklace there to grant some bonus stats, or maybe have some unique medallion after completing quest with Kerry. There's the gun you get from completing the quest line with Johnny and some legendary item recipes for Johnny's gear.
(going back to loot)
In general, increase carrying capacity and reduce drop rate of common loot (guns, healing items, armor) and give us more things like "gun parts" or something else that's not immediately amounting to more carry weight and can be easily stacked.
Also of course consumables need to be hard looked at. There's currently only 1 good item to consume and that's the 1 extra ram in case your hacking isn't strong enough to execute the Cyberpsychosis quickhack.
(just repeating my opinion from other topic)
As I suggested in my own topic that the crafting tree should be completely abandoned (or made completely separate that's isolated from perks and attribute points) and being replaced by "robotics" and allow there to be Netrunners with drones, or stealth assassins with drones that you can use to distract enemies. Or maybe a healing drone for the beefy frontline high hp juggernaut with full armor set.
Netrunner cybernetic fist implants with a cool jacket/cloak.
This is what people like to see. Characters specializing in certain playstyle.
Show us Johnny Silverhand when he was fighting in corpo wars and wearing a ginormous mech suit taking out Arasaka troops. Maybe he's about to pull some fellow soldier from the ground until the soldiers hand snaps in 2 when a laser cuts through the field. Just a small teaser on what took place before the game starts. I'm not so much familiar with the lore but didn't he lose his whole hand in the wars? Maybe you get to witness that as a part of the memories that you share with Johnny on your journey.
And actually have some high end talents to change how you execute some attacks, similar to how in Star Wars Fallen Order, you can execute a ground slam by pressing strong attack in air.
Specializing in crafting is only good for basically saving money, and same goes for many perks in Breach Protocoll. They just can't work in PvP (whenever that comes).
So TLDR of my past 10 posts: Some tiny quest reworks (in end of quest line). Some talent reworks(among them the ability to control drones). Loot system improvements. New difficulties, and even survival mode. Mercenaries coming after you after finishing the heist.
(In general I'd just remove the whole thing with having to wait a day for shop to restore the items for multiple purchases. It's just taxing and serves no purpose.)