Looking to purchase

Looking at buying a Ford Expedition Max and I need help. I’m having the hardest time finding the right one, we’ve been looking for over 2 months. When I think, I had it figured out. I opened up a can of worms by reading Reddit posts about what years are the best, problems, etc. This has now limited my search even more.

I started looking at only late 22s or 23s because they are newer models with fewer problems from what I read. I’m trying to spend around $40kish or less (if possible). I have 4 kids and need cargo space and bench seat which is hard to find in the expeditions it seems. All the ones in my price range are usually rentals or dealership are being shady so I walk. Should I look at other years?

Reddit says not to buy a “Covid” car (2020-early 2022), also read 2018 and 2019 are not good models. So I’m feeling very limited. Also I read to get an extended warranty but idk where to look and which one is good or even what I’m looking for. How much should I spend? Idk if we should try from the dealership or look outside of dealer.

I need advice, is my price range even realistic? I feel like I’m looking for a unicorn. Should I buy an older model and get an extended warranty? It’s been like 8 years since I’ve purchased a car and I’m also not a fan of getting a car payment, not that we can’t afford it. Its just an extra expense but we really do need a “newer” car.

We have a 2014 Honda pilot and have had to do a lot of repairs. I don’t want to go through that again.