It does not make a lick of sense to bring up XCOM in this context, that's a completely different type of game with a completely different type of mindset behind it.
Not everyone likes playing one-shot, die-and-restart-from-the-beginning games. The Rogue-like/Rogue-lite genre tends to have short simple gameplay loop. Not a 100+ hour long game. Not a lot of people want to get to hour 89, have a party wipe and need to go back to the start, seeing 89 hours of the same content again just to get back to the 11 hours of new stuff.
I brought it up as an example of how hurting the player can improve enjoyment of a game. If everything is easily achieved, your sense of accomplishment will suffer. In terms of BG3, maybe not being able to own every magical weapon there is will increase your satisfaction of having the one magical weapon that you were able to obtain and keep.
