Here is a link to the hotels around the airport. Hartsfield-Jackson Atlanta International Airport
You will have a much shorter trip from Birmingham to the airport than to Roswell or Alpharetta. That doesn't make much sense to me. Travelling in on I-20, get on I-285 South and go about five miles to the airport. You can't beat it.