The six-cylinder nails the sweet spot between performance and affordability in SUVs, and thankfully there are some great choices out there.