How did I know that would be the first answer... I used the work "hookshot" because it was the only relevant word I could think of.
Automated grappling hook, how's that?
Are you talking about a hookshot like in Zelda, where you shoot it and it pulls you in automatically? If so, I don't know if that would fit in the game. A bit too unrealistic and cartoonish for a TES game.
Now, if you were talking about shooting a crossbow bolt with a rope attached and being able to climb the rope after it stuck to something, then that would be a bit more feasible. Though I still can't really see it as being added to the game. Maybe something for a modder to add later, like what Scruggsy did with his Thieves Arsenal mod.