If you have ample disk space, the Auto option will use some of the disk for the read-ahead cache. If your disk doesn’t have a lot of space, then Infuse will automatically switch to memory (RAM) instead of disk.
Memory Only and Legacy are limited to the available RAM on the device, so the amount Infuse is able to cache will usually be lower.