As you said they have their place. I don't think every campaign had to be 100% customized to the players. Twinkle the banished necromancer doesn't belong in Waterdeep Dragon Heist, but the player can make a character that would fit within that setting.

If you want it 100% then you can jam a character peice into a campaign puzzle if you really want to. It just requires work.