"Just never drop columns or tables, those require a human anyway, unless they're tiny."

In a lot of common multi-tenant designs you could have thousands of schemas. You can't have a human doing this. Additionally, the hard part of schema versioning is really the data migration and rollback steps which you failed to mention.