I'm a bit surprised nobody mentioned autocad map 3d. It is autocad with extra support for gis data, and contains many routines to convert from dwg (or use simultaneously) to the formats supported by fdo, including spatial databases and eg shapefiles.