Hydrogen in diffuse molecular clouds in the Milky Way - Atomic column densities and molecular fraction along prominent lines of sight