Most Americans say workers should receive paid family and medical leave, but level of support varies depending on the circumstances