Sharp weighted log-Sobolev inequalities: characterization of equality cases and applications