Orbital outcomes of STIPs and consequences for hot-Jupiter formation and planet diversity