How should I repair this poor deck rim joist connection?
Try 2 Simpson HTT4s. The clip is screwed to the short ledger and long carriage bolts are drilled through the joists to draw back the floppy rim joist. Long bolts with washers will hold better too in my opinion, but may not look as neat.