I have the Super HuCard CD for my PC Engine Duo. It loads the games into the PC Engine ram, but it works only with smaller games (1-2 MBit HuCard games). The most titles doesn't work properly, or freezes later in the game.
Anyway, i don't know if something like that is possible for the Mega CD. There are flashcarts for the Mega Drive, probably a better solution.