I heard of one program for the C-64 with two drives. You load the code into the drives, and it would copy a disk without the C-64 being on.
Imagine I want to select data from a Parquet file and I could load a program into the storage device to only return me the entities I want instead of reading data into main memory and have my CPU do that?