Absolutely their should be transportation, I mean that's what I assume anyway. If you want to stay in a relaxed "no hustle and bustle" suburb, go for Eden Prairie or Chanhassen. There's relatively no night life, just two quiet suburbs. Chanhassen has a great dinner theater if you wanted to do something fun at night. Plus you'll be close to the course. I advise against Bloomington, never been a fan. However the Mall of America may have transportation going to the course that weekend, and the new hotel they just built there is gorgeous. I assume that is what a lot of people will be doing.
Anybody that want's to share the Ryder Cup with some night life will have to stay in Minneapolis. Something like the Raddison Blu or Foshay Tower or anything downtown off of 7th St. would be the way to go.
So yeah to break it down.
Quiet easy weekend - Chanhassen (may have to check on transportation, course is close though)
Party weekend - Any nice hotel off of 7th st. Minneapolis
Fill up fast - I assume the Radisson Blu at the Mall of America will fill up fast, it's close to the airport and the Mall will give you plenty of things to do.