The default option is “Normal.” Which rotates the photo layer in the direction you intended.
The “Corrective” option does the opposite of what you’d expect. At first, this may seem in-practical. But when you’re trying to straighten a horizon, this might provide better, faster results. You’ll have to try it out to see for yourself.
When using Corrective, make sure to go to View > Grid to turn on grids to assist with the rotation. With the Rotate Tool active, click on the image layer and rotate the grid until the horizon matches the horizontal lines.