I think by rock bottom, we could mean tragedy. Where the protagonist has everything and loses it, never to recover it. Hamlet, for example.
Or film noir. Where the protagonist never had it and never ends up with it, despite usually coming close to attaining it or having it briefly. Paradise...
In Bruges
One Way To Copenhagen
The Machinist
Taxi Driver
Bad Santa
The Break Up
A Star Is Born
Forgetting Sarah Marshall
Barfly
Down and out in Beverley Hills
Harvey
Arthur
There Will Be Blood
Locke
Very Bad Things
Reversal of Fortunes
It’s A Wonderful life
Last Exit To...