Mike, the movie you were trying to remember with James Mason popping pills is Bigger than Life, directed not by Nicholas Roeg but Nicholas Ray.
Book that made me cry my friggin' guts out: Shot in the Heart by Mikal Gilmore. Family memoir by Gary's little brother. At the end? Big, racking sobs. Projectile tears.