"Skye Boat Song" is somehat unresolved, it always makes me cringe when singers finish it off with a strident tonic.

"McPherson's Rant" is a classic of this type.