“Hand Jive” by various artists. 
At Last --Etta James
I’m in a long distance relationship so it would be either the “transportation” song:
You can reach me by railway…
I don’t care how you get here
Just get here when you can…
or the “mountain” song:
There ain’t no mountain high enough
Ain’t no valley low enough
Ain’t no river wide enough
To keep me from gettin’ to you…
right now, probably “Damn, I Wish I Was Your Lover,” by Sophie B. Hawkins. Then there’s also “Toucha Toucha Toucha Touch Me” from The Rocky Horror Picture Show, for when I’m in one of my, er, “moods.” Here I am a college virgin with absolutely no romantic experience whatsoever… but I don’t mind.
Geobabe already clarified, but yes, I am most definitely referring to “Both Sides, Now” as sung by the one, the only, Joni Mitchell. (If you’ve never heard her version, I recommend it. No one can make you feel a song straight through to your bones like Miss Mitchell can).
The other song that comes to mind is “I Know” by Fiona Apple:
“And when the crowd becomes your burden
And you’ve early closed your curtain
I’ll wait by the backstage door”
Centerfold, by the J. Geils Band
What?
Solitary, by VNV Nation. Ok, the lyrics don’t have much to do with it, but the title fits.
Naive Melody.
Because I am home
Cos I know what it means
To walk along the lonely street of dreams
[snip]
Like a drifter I was born to walk alone
[snip]
Waiting on love’s sweet charity (for the last 5 years)
[snip]
An’ I’ve made up my mind
I ain’t wasting no more time
taking back sunday - cute without the ‘e’ (cut from the team)
how about i’m outside of your window
watching him keep the details covered.
you’re such a sucker for a sweet talker. such a sucker.
*** Jungle Love***
-eat your hearts out…
Comfortably Numb - Pink Floyd 
“On My Own” from Les Miserables
At least Eponine had Marius to comfort her in the end…
Another Day in Paradice by Phil Vasser.
A sappy, washing machine broken but I love you anyway, honey ballad. I can’t help if it seems to have been written for my S.O. and I.
Girls of Summer, Aerosmith…
My favorite thing that drives me wild
S’when a city girl walks a country mile
For the boy she loves, God bless the child
Inside the girls of summer
I live in the city and she lives in the suburbs, she has a car and I don’t. 
Loser by Beck 
Control ~ Janet Jackson
I’m apparently in the same boat as mayberrydan…Songs of choice (with lyric references):
Blink 182 - Happy Holidays, You Bastard (Ejaculate into a sock…)
Blink 182 - Story of a Lonely Guy (Girls possess me but they’re never mine…I’m always nervous on days like this, like the prom, I get too scared to move ‘cause I’m a fsckin’ boy)
Green Day - Longview (When masturbation’s lost it’s fun, you’re fsckin’ lazy…)
Green Day - All By Myself (You and me had such wonderfull times when I was all by myself…)
Come to think of it, Blink 182’s Take Off Your Pants and Jacket CD is all about horny teenagers. At least more than usual…
Anyone else feeling like we need an SDMB Singles Club forum?
Somebody - Depeche Mode. Yeah, I’m another morbidly single person.
Well mine would have to be “Somebody Kill me Please” you know, the one Adam Sandler sings in the movie “The Wedding Singer…”
'Nuff said.