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).
USAA. Chase does, too, though I only use them for credit credit cards. Citi the same. I also know that E*Trade and Schwab do.
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.
