A lot of the good ones have already been mentioned. I'm not sure if my list completely follows the theme, but here it is:
The Long Grift from Hedwig and the Angry Inch
Hey There from Pajama Game
Without You from RENT
How Many Women in the World? from LaChuisa's The Wild Party
An Old Fashioned Love Story from Lippa's The Wild Party, humorous as it is.
Dear Friend from She Loves Me
A few songs from Tell Me on a Sunday/Song & Dance
Lonely Pew from Reefer Madness, lol
Not from a show, but Kerry Butler's version of When She Loved Me from Toy Story 2 on her solo album.
And just because I'm a stickler for this. It's The Rocky Horror Show, not the
Picture Show, that's the name of the film. Once in Awhile isn't in the film, it was recorded and shot but was left on the cutting room floor.
You're reminding me of people you hear at the movies asking questions every ten seconds, "Who is that? Why is that guy walking down the street? Who's that lady coming up to him? Uh-oh, why did that car go by? Why is it so dark in this theater?" - FindingNamo on strummergirl
"If artists were machines, then I'm just a different kind of machine...I'd probably be a toaster. Actually, I'd be a toaster oven because they're more versatile. And I like making grilled cheese" -Regina Spektor
"That's, like, twelve shows! ...Or seven." -Crazy SA Fangirl
"They say that just being relaxed is the most important thing [in acting]. I take that to another level, I think kinda like yawning and...like being partially asleep onstage is also good, but whatever." - Sherie Rene Scott