Strong disagree. On many instruments there is a strong memory association between the place of the note on the staff and the physical movement to play that note, Wether it be a fingering, valve combination or lip tension or whatever.
I agree. Even though some (most?) instruments have different shapes for each scale, notation should transcend implementation and aim for the most general representation. See: isomorphic instruments.
I'll concede that traditional music notation is the most efficient way of representing classical music.
With sheet music, transposing music means moving it up or down the staff, and changing the key signature to match, and adjusting any accidentals.
Music theory gives good reasons for changing keys to have a significant effect on how the song sounds. Most pianos are tuned equal temperment so you don't get that effect, but there is a good argument for other tunings that do. (You may or may not agree, but the argument is valid)
I'm not convinced, personally. Melodies that sound the same don't really sound the same (hitting different registers on the same instrument), and they aren't played the same (different fingerings), so why would they look the same in notation?
Part of me says yes and part of me says no. The thing that music notation recognizes is that which specific notes are important changes depending on which key you're in.