"Best" is what's best for you
"Best" is what's best for you. I'm no longer at an age where "fun to drive" is a high priority; I have an 1100cc motorcycle for that. Storage flexibility was high on my list of priorities, which is why I bought a Honda HR-V 10 days ago. At ~200 miles, I am completely captivated by this car, which is far more luxurious, quieter, and more comfortable than the 2009 Fit Sport it's replacing. The HR-V isn't quite as much fun to drive as the Fit, but it's a hell of a lot more comfortable.
If I want 4-wheel fun, I would probably go for a used Miata.