Great song.
Was gonna be trite and say Sigur Rós or GYBE! or someone, but your question is vulnerable, so...
"A Lover Sings", Billy Bragg.
Not as lyrical as your Red House Painters example, but it's evocative and sweet. Check out Dylan's "Wedding Song" and "Love Song" by the Cure, plus others by Bragg ("The Only One", "Brickbat") for more "awww... help, I'm being nakedly openly vulnerable" moments.
― David A. (Davant), Friday, 11 April 2003 05:23 (twenty-two years ago)