Apple Maps on CarPlay added this feature and I love it. It works great for routes where I pretty much know the way but want a heads up for traffic and such.
I guess, though, I would probably only want navigation to stop if I'm going to my house, not from it.
[1] It seems this has gotten better in recent years with less frequent nagging to "proceed straight for 50km" from the app.
The worst example I've had is that a road changed it's name 70m before it split into two. The app would only show "In XXXm, continue straight" then, with 70m warning, it told me which lane I needed. That was stressful.
Apple Maps in CarPlay has this option, and I only ever use it muted. It’s fine even when I don’t know where I’m going, since I just glance at the screen to see the next turn/distance and that’s all I need anyway.