It is not automounting but there is a an xfce mount
plugin that allows you to quickly mount devices, including CD's. If you frequently need to mount media it may be the next best thing.
A OpenBSD binary package is available. J65nko also has written a
howto regarding user mounting of devices.