With the Starwood AMEX, you really aren't dealing with AMEX regarding the transfers. So even though US Airways pulled out of Membership Rewards, they are still a part of the Starwood program. So you can use the Starwood AMEX, rack up Starwood Points, and then transfer them to US Air.
I have to agree that airline rewards are getting harder and harder to find these days. We were lucky to find 2 Upper Class rewards to London on Virgin for our Dover to Monte Carlo cruise this August. Virgin was able to hold the award for 72 hours even though I had 0 miles in their program. That gave me time to transfer from Starwood to Virgin.
Of course there are many places you can't use AMEX. That's when the Visa/MC for your favorite airline comes in handy.