I’ve got a CX-5 that I really like, but I don’t consider it small, so I’m not sure exactly what the parameters are. My daughter has a Crosstrek and really likes it, too. I have no problem with the Mazda, and I’m not in the market, but I’d consider a Subaru.
I just bought a used 2019 BMW X-3 with around 50k miles for $23k. I don’t know if it’s “best” for the money, but it’s a lot of fun to drive.
My sister’s RAV has 320,000 miles on it. She swears by it.
Mrs. Cretin and I loved our 22 year old Subaru Outback; We love our 3 year old Forester even more.