There are almost no SCD games that work differently with an ACD installed. Even fewer of these work to cache assets in the way you are describing. Maybe two? I don’t know if I have any. 3x3 Eyes, if anything, is putting more work on the CDROM with its eternal mega loads that take longer than any 10 SCD games combined to complete.
You’re thinking of PCs, not consoles. 8 bit games are dumb and always assume the exact same amount of RAM is available, ignoring anything else, unless specifically programmed to take advantage of it. You may as well have Bonk in the slot.