DLLs will be gone along with all dynamic libraries when 16-32gb of RAM will be standard on entry level computers.
It was invented to conserve memory space, most of the time its just a lousy alternative to static linking.
I've seen many Linux apps switching to static to reduce errors and dependencies.