Can we automatically make a users Drupal account inactive when their membership expires?
Making the account inactive is probably not the best user experience.  You could use CiviMember Roles Sync, permission your member content appropriately and show your inactive members the renewal page.