I would like to have my USB flash drive auto-run a file on it when plugged in.
You could use Automator and folder actions on the /Volumes/ folder.
Just open Automator, add a new folder action and click Choose Folder. When the popup comes up press Command-Shift-g and type /Volumes/. Now just create a Workflow App that will be triggered whenever a device is mounted.