Extreme softening of Vanderbilt pseudopotentials: General rules and case studies of first-row and<i>d</i>-electron elements