Are there impairments that automatically qualify someone for Section 504?

No, each decision on eligibility is made on an individual basis.