ArcGis does allow you to write your own VisualBasic/SQL/etc extensions, should you wish to do something really specific.

Apart from that I only ever heard of ArcGis and something obscure in the back of my mind something related to Autodesk...

Link for ArcGis: www.esri.com