I believe you are thinking of "Little Angel, Little Brother" by
Lucinda Williams, recorded on her album "Sweet Old World," released in
You can see the lyrics here:
The lyrics mention "wisecracks," "passion for Shakespeare," and
"rugged good looks." Other parts that match your question are "I see
you leaning your lanky frame/Just inside the door/A figure behind the
kitchen screen" and "I see you sleeping in the car/Curled up on the
back seat/Parked outside of a bar/An empty bottle at your feet."
There is no explicit mention of suicide or death other than the use of
the word "angel." There are two other songs about suicide on the same
Lucinda Williams's website
As it happens, I just listened to the song today, so I recognized it
from your description.