In New Google Sites embedded (not "uploaded") files are stored in the Drive of the user that embedded the file, but not in any specific place.
There's not much point in developing solutions for Classic Sites as it is being deprecated, unless your goal is to create a process to migrate away from Classic Sites, of course. :-)