On Windows, it used to be the default to just run, yes. Made a good infection path for viruses.

Mac OS X could open up a generic dialog that asked if you wanted to drag and drop the app to your hard drive to start installing it. Linux depended on the distro, but generally GUI-based distros would open the file manager to the CD path if they did anything at all.