Really, any of the airport area hotels would work fine for a vist to MoA. Worst case, the courtesy shuttle can take you to the airport and you can take the light rail a couple of stops south to the mall. But often times, if the courtesy shuttle isn't busy, they won't mind dropping you off at the mall, maybe even on the way to/from MSP. Just ask nicely.

I can't think of any one particular "must see" at the MoA other than just devoting enough time to walk it. Each section (North, East, South, West) is themed in name and decor, so it's fun to walk between the sections and watch everything change to something new. There are a few clubs/bars way up on the top floor, and I think there is still a comedy club in there, too. The movie theatre is great for a rainy day/mall day, and there a good mix of sit down restaurants and typical mall food court stands. If you're into marine life, oceanography, or just being under water, a visit to Underwater World might be a good idea. It's a little pricey, but it's fun, even as a grown-up. If you look around the web, Entertainment books, etc. you can usually find some discount coupons for entry.