Cars are an expense, not an investment. Don't waste your time looking at depreciation rates & resale unless you plan on flipping it for another one every couple of years (and in that case you should be leasing, not buying).
Get what you like best in your price range & enjoy driving it.