The main difference between the Administrator and SYSTEM is that Administrator is an actual account (for example, it has a password) whereas SYSTEM is not. (Properly speaking, SYSTEM is a "security principal".)
One practical difference is that, if the computer is joined to a domain, processes running as SYSTEM can access domain servers in the context of the computer's domain account. Processes running as Administrator have no access to domain computers unless the password happens to match or alternative credentials are explicitly provided.
It is possible for a file, directory, registry key, or other securable object to only grant access to SYSTEM and not to Administrator. However, I'm not aware of any examples on a default installation of Windows. Edit: I forgot about the SAM key, containing the local account information. This has full control granted only to SYSTEM, with the Administrators group having neither read nor write access. Kreemoweet has also pointed out that Vista has a number of other examples.
Of course, the administrator can override any permissions anyway.
There are one or two oddball special cases. For example, the WTSQueryUserToken function allows a program to get an access token that can be used to launch a new process in the context of a specified logged-on user. This function can only be used by processes that are running as SYSTEM, not by processes running as Administrator.
1On Vista, the default ACL's on innumerable registry keys and files reserve full control to System or TrustedInstaller. The \winsxs\ and system32\drivers\ folders are two such. The security properties of many registry keys can not even be viewed by Administrators. – kreemoweet – 2012-11-12T05:23:53.763
@kreemoweet: Interesting. I haven't had much to do with Vista. In Windows 7 the permissions on both the winsxs and the drivers folders are the same for Administrators as for SYSTEM. (The really strange thing, of course, is that permissions are explicitly granted for SYSTEM at all; that's redundant, since the SYSTEM token always includes the Administrators group.) – Harry Johnston – 2012-11-12T19:46:35.317