We just watched "Requium for a Dream" a movie from 2000 with Jennifer Garner. It is about 4 people who go from using no drugs/casually to a total descent into addiction hell. Very powerful movie. I highly recommend it.
Just want to add that this movie is not for children.