Assume SilverStripe 3 (I'm not sure it matters which point version).
If you want to replace a file ("Files" tab, for /assets/ directory), you go to the "Files" tab, locate the file, click the edit icon, select the "Replace" tab, and replace it that way.
BUT, if you don't do this often and haven't noticed/remembered the "Replace" tab, it's not unreasonable to try loading a new copy of the file. That wouldn't be a problem if the error message you got for a clash of filenames was more helpful, but what you see is "File with the same name already exists" followed by a logo-with-text saying "Overwrite".
It's not unreasonable to assume that "Overwrite" means you'll overwrite the file with the same name. That's not what happens. Instead, the file is saved as filename-2, and the original file is still there at filename.
I'd like to replace "Overwrite" in the text above with something like "Save anyway" - possibly with a note that the filename will have a number added. Anything to make it clear to an occasional content loader that the successful overwrite they did didn't actually change the original file in any way.
Thoughts? Are we the only people who've run into this? :)