The Right Thing, I believe, would be something like
(load-foreign-library "foo.dll" :name :foo)
(defcfun ("FooFun" foo-fun :library :foo) ...)
maybe one could create a defcpackage and an in-cpackage that map directly defpackage and in-package with a hashtable behind the scenes mapping from packages to foreign libraries.
just some idea,