Are you interested in hotel programs as well?
Others have hit mine with regards to Delta.
Hilton
Best - Diamond members are promised upgrades if available and free breakfast, as well as the diamond line for reservations.
Worst - Inconsistent execution of the benefits depending on the property you stay at.