Yes, most airports in this country
have crappy transit connections much as most cities have crappy transit, but we do actually have some decent ones. Off the top of my head there's Portland, Seattle, San Francisco, Chicago, Minneapolis, Baltimore, Philly, Washington (National), ...