Running a sync corrects the issue (restore the proper file count in wp_file_cats), however as Jadhisno stated above the category will reset to 0 after the file is delete.

Any help on this issue would be much appreciated.

Thanks Fabian!