$25-27K out the door

I've been car shopping for a minute and my budget is <25-27K out the door.

So far I have found a Hyundai Sonata Hybrid Limited 2023 which I love in that price range (with 40K+ miles), but I'm wondering if maybe there is a new car or another 'nicer' low/mid price car I'm missing.

I was really between the Hyundai Elantra Limited or Sonata Limited. I love the dash and the general look of it. I don't drive more than 6K miles a year according to my Ford Fiesta 2012. I'm not even too bothered about getting a hybrid, but I'm open to it. I mostly want this purchase to last and something I'm comfortable in 10 years.