I’m looking for canals that were built in the expectation that sea-going ships (not barges) would go from one ocean or sea to another (or even the same one) in order to avoid going around some inconvenient land mass.
I should have spelled this out in the OP, but I figured it’d be obvious (I really should know better, though).
The fact that the canal uses lakes or other bodies of water connected by canal sections is not a problem. As long as it’s a single project intended to connect the two seas for ocean-going ships, which that was.
Now how many of these are still in use for ocean-going cargo ships? A goodly number of them are currently only used by pleasure craft or tourist excursions. That includes the Canal des Duex Mers, all those Scottish canals, the Göta Canal, and the Corinthian Canal. As far as I can tell, the only ones still in use by cargo ships are the first 5 in the list in the OP.