Actually the backup plan almost every time was to just stay on the ISS until another Shuttle could be prepared. They only had another Shuttle on standby a couple times, during missions where they weren’t going to the ISS.
>They sent up equipment and materials for repairs in space with every launch, though admittedly the usefulness of that was dubious and the repair kits were never used
Yeah it wasn’t even useful for a situation like Columbia. It didn’t lose a few tiles or something, it had a giant hole punched into its wing.
There’s no fixing that in space. So I personally think they focused on situations they could theoretically fix, even though those situations weren’t what happened to Columbia.