I've done some experimenting with my first revision WIP cartridge that relies on !AS to trigger cart !OE (so the 68000 correctly outputs, but the DMA is ignored) which may help anyone doing any emulation/hardware work relating to DMA or the !AS signal:
Fully working without DMA:
Syd of Valis
Duke Nukem
Player sprite needs DMA, but not background: (title screens and intros work as well)
Mr. Nutz prototype
Mobius Evolution (and I assume all Sonic 1 games and mods)
Bubsy 1
Ecco: The Tides of Time
Zero Tolerance (only the FPS gun sprite needs it)
Background tiles need DMA but not character sprites:
Awesome Possum (title works and speech, but not backgrounds)
Heavily reliant on DMA:
Mega Turrican, opening marquees don't require DMA. Ingame tiles and sprites do. Shows a solid coloured screen without DMA.
Overdrive by TiTAN (of course

)