We use Salesforce.com.
http://www.salesforce.com/
The main value is that it integrates support with CRM, so salespeople and account managers can have some visibility into support cases for their customers.
It also has a web services API available to get data in and out but you have to pay extra for that.