The Hilton Garden Inn is the closest to the airport. It's very nice, we've stayed there several times, and would have no problem staying there again, but it's going to cost more than the Holiday Inn express or Best Western.
Just an FYI on that Holiday Inn Express...if I'm not mistaken, that's a pretty old motel that's been refurbished, but it's still not going to be the nicest place. The area it's in is safe enough though, which is nice.
Here's an idea, look a little further North in Clifton Park. There's a Hampton and a Comfort Inn, as well as another Holiday Inn Express that are all relatively new. The Best Western up there is probably the oldest property in the area, and that's maybe ten years old now. From any of those four hotels the Albany airport is an easy 20 minute drive--plan on half an hour if going during morning rush hour mid-week.
Anne