I think my ‘04 Honda Accord was a lemon, relatively speaking. At about 170,000 miles, when I sold it, it had a CEL and code which indicated that most likely it was going to need valvetrain work - probably a new chain and sprockets at the least. It also used a quart of oil every 1,500 miles or so, starting from when I’m not sure - I had (lazily) gotten out of the habit of checking oil levels because my previous Nissans had spoiled me by using hardly a drop between changes. Nissan builds really tough engines. Anyway, too bad about the Accord, because otherwise it was in excellent shape.
I think the large pickups and SUVs have another factor in play - these things actually have utility, and people are often willing to put money into them to keep them going. Older cars aren’t so desirable - the people who can afford to fix them want newer cars, and the people who end up with those older cars often don’t have the money for major repairs (transmissions, major engine work), or it’s just not economical for a vehicle that’s not worth much anymore.
I also find that small engines with automatic transmissions tend to burn out relatively young, because they spend so much time turning higher rpms. It’s not as bad with manual transmissions where you have more control over rpms.
They were taken off shore somewhere and dumped overboard...cheaper to scrap than to fix. (They were REAL small cars then)