Certain programs will not load (eg. crash).
However, what is interesting is if you use the address returned from LoadLibraryA("...notepad.exe"), and then treat that memory as the file you mapped (or fopen/read in, whatever), it works.
Many PE loaders have this issue... LoadLibrary is doing some kind of fixup-magic .