I agree that this is how most legislation does work: dream up something that would be great and ignore the facts on the ground and live with a predictable shitshow of implementations.

To me it's a stretch to say legislation ought to work like this.

Many of the "outlier good ideas" in legislation are those that integrate the facts on the ground and consider e.g. implementation complexity.