Yep, loss of OFX was the impetus for me to finally leave Capital One. They gave me the runaround for a week then admitted they turned off OFX, after trying to blame my software (Moneydance, which I highly recommend).
For USAA you need a military angle to get in. My dad served in the Army, so that was enough. If you have any close relatives that have served, you can get an account.