My first full time boss quit over this. He was there 10 years and his life revolved around support as nobody else stayed more than a year, so nobody ever learned many of the systems.
some people like to be in this position, although I find those people have a way of stretching out every support or maintenance task that should take hours into weeks
That is more like after the long haulers have left and the new people have to figure it out. The guy who wrote it can probably fix in 5 minutes, the next guy is paid more but takes 5 days.