You're correct - the overhead of 1 mdl_files entry is per context (per resource created).
The scenario I described is the worst case - it's when a site has course with file resources that contain only 1 file. Unfortunately, on live installations this is the most common use case.