Super Metroid and DMC4 maybe?

indeed

mega man zero 2

does persona 5 royal count? (royal exclusive content)

hell yeah

Lego Batman: The Video Game

DOOM Eternal has a grappling hook on a shotgun. Genius. The best kind of shotgun.

castlevania 4 sorta?

If Metroid is on here, CV4 should be too!

Uncharted 4

There are several Sonic games with a grappling hook of sorts. Sonic Unleashed (if the Werehog's stretchy arms that can grab ledges/poles counts), the Sonic Boom games, and Sonic Forces.

ultrakill?

RE4make Separate Ways.

nier automata, you can get a pod program in a side quest that's just a grappling hook. also kingdom hearts IV, not out yet but sora uses a grapple hook ability with the keyblade in one of the trailers