You can prevent automatic execution by disabling AutoPlay entirely for removable drives.
For CD-ROMs and DVDs, this was a miracle. Insert an educational disk, and the learning portal launched instantly. Insert a game, and the installer started. When USB flash drives became cheap in the early 2000s, manufacturers replicated this behavior for USB mass storage devices. Autorun USB