Yea, I hear ya... There are a variety of ways you can change the file names via automated tasks on a Mac & PC. I think the file names only restart when we reformat the card or it reaches a set limit??
I sadly (in eagerness to see what a I shot immediately!!), overwrote some great Hawaiian mountain footage by being in a rush, and dumping the files in the wrong folder full of older video files. Not paying attention, I clicked ok to replace the files—because what I shot was so damn good...... I think, b/c I never saw any of it.

.
Ever since then, I make a folder with the date/location of all footage (like 12-9-19BlackMtn), and dump the files straight from the drone there. Then, I immediately copy the folder to my video BU HDD. When I edit, I make another folder with the name of the project on yet a 3rd HDD, and dump the files I like in there, dupe that, then edit. Did I get anal about it or what??