That's right, if a file with the same name already exists, uploading a new one will override it, preserving the download count. Otherwise if you delete it first, the per-file download count goes with it. The project's overall download count is preserved either way.
As for the limit, by default I think it's 1GB for uploading through the browser, and 2GB through Butler, but you can contact support and ask for an increase.