All modern Linux distributions should support automatic mounting of removable devices for normal users through HAL/UDEV paired with a capable desktop environment.
Unless you mean on the console. Without the DE listening for HAL events, nothing is in place to mount the device. To that end, there are HAL daemons that run separate from the DE (such as ivman
), which might be what you are looking for.