The longest trip that I've ever done were the Montreal - PEI trips. Of course, I've done it eight times, mind you.
did it once from PIE to Toronto, didnt plan to go non stop but till Montreal it was easy so we decided not to waste money on motel/hotel.
After midnight torture began when your eyes on fire and you have to stop on all gas stations on 401 only because we left shortly after noon and trip ended at 4 am
drove to PIE with stops in Ottawa, Montreal, Quebec city, Halifax, Cape Breton, PEI
perfect car for that was SAAB 9-5
trip Amsterdam->Cologne->Lucerne->Monaco->Nice->Avignon->Lyon->Strasbourg->Luxemburg->Cologne->Amsterdam in 4 days was pretty easy in Citroen DS5
would love to go to Vancouver but not sure if Mazda3 will be wise choice for such trip