Membership, binarity, and rotation of red dwarfs in the nearby open cluster Coma Berenices (Melotte 111)