I reviewed a similar
Capital One $200 bonus last year. It was a targeted promotion, but some readers reported being able to get the bonus at a branch. So it's a "Your Miles May Vary" (YMMV) kind of deal.
This new one was mentioned in this
SlickDeals thread. The new promo code is RD2, and the offer is scheduled to last until 11/30/2010. One plus as compared to last year is that it doesn't require direct deposit. They only require 2 debit card purchases.
It appears to require a branch visit. Branches are located in Texas, Louisiana, New York, New Jersey, Connecticut, Maryland, Virginia and Washington, DC (The branches in the DC metro area were just recently converted from Chevy Chase Bank)