there are many streams that no one ever canoes down, because it would be an enormous pain. There isn’t a way to represent this is OSM today

Had you considered `canoe=discouraged`?

https://wiki.openstreetmap.org/wiki/Key:canoe#Access_values

paddling is technically allowed but may often be unsafe or impractical (e.g. open water or shallow creeks)