For those of you suggesting a Honda Accord, it's definitely on my possibilities list. But the local dealer has none in stock at the moment. Apparently they've had hardly any 2021 stock - probably due to the chip shortage. I'd be looking at the 2.0 Sport or Touring. I prefer a car with a bit of Zoom.
I should have bought an Accord Sport 2.0 6MT but by the time I found out they had stopped making them, the only ones left were black, which I didn't want.
Another car we've looked at is a Lexus IS 300 AWD with an F1 Sport Package. It's very nice too but quite a bit more expensive (about $10,000 Cdn more).
My ideal next car would be mid-sized, sporty, attractive, have reasonable fuel economy, comfortable for 2 adults on a long drive, roomy enough for 4 adults on a short trip, reliable when new and not likely to be crazy expensive to maintain when it gets old. As you can see I keep my cars for a very long time. I'd prefer a manual transmission but they've become quite rare. And I would like a spare tire and an engine oil dip stick. I don't really want run flat tires, a flat repair kit, a CVT or DSG transmission and I'd prefer to avoid unnecessary complexity like engines with cylinder deactivation.
To be honest, none of the cars we've driven so far are as nice as our E39 BMW. It has a manual transmission, an M-sport package and an interior appearance package. It's still a beauty. It has a real spare tire on an alloy rim, and an oil dipstick. And it has only 163,000 Km (about 100,000 miles). Another option is to restore it, to proactively fix all the things that hang over your head with an old BMW - like all that expensive plastic stuff under the hood. But then I'd have an excellent 20+ year old BMW - which is not what I'd describe as the ideal long distance car.