Current Mouse Position in Your Game
Point the Sprites right direction at the Mouse
Rotate at a Constant Speed
Rotate Using the Left and Right Arrow Keys
Orbit Around a Point
"How to Make a Homing Missile" (9min, Oct 2017) by Brackeys.
"How to Make a 2D Ranged Combat System" (11min, Aug 2018) by BlackThornProd. A video of how to rotate a 2D gun to face in the direction of the mouse cursor, so it can shoot in that direction.
"Rig and Animate 2D Characters in Unity 2018" (23min, Oct 2018) by Sykoo. A video on how to rig up a skeleton 2D character made of many sprites, then animate how they move together.
"Intro to Quaternion Rotations" (33min, Sep 2017) by Hardly Difficult. A very detailed look at the basics of 3D rotations and Quaternions.
"Quaternions - Unity Official Tutorials" (6min, Sep 2013). A really brief overview of Quaternions and rotations.