Self-hosted CRM means the contact records, the pipeline, the quotes and the email history live in a MySQL database you control, on a server you chose. The three open source CRM platforms here reach that in different ways. Dolibarr is an ERP and CRM in one, so invoicing, stock and purchase orders sit alongside contacts and opportunities. SuiteCRM is the long-running open source fork of SugarCRM and is the closest thing here to a traditional sales CRM, with workflows, campaigns and a module builder. Vtiger Open Source is the community edition of a product whose vendor also sells a hosted version, so the two should not be confused when you are reading feature comparisons.
What they compete against is a per-seat subscription. Salesforce Sales Cloud, Microsoft Dynamics 365 Sales, HubSpot, Zoho CRM, Pipedrive and Freshsales all price per user per month, and most of them put the automation people actually wanted a tier or two above the entry plan. That model works for a four-person sales team. It gets awkward at twenty people, because the cheapest way to control the bill becomes restricting who can look at a customer record, which defeats the point of having a CRM.
Self-hosting removes the per-seat maths and hands you the maintenance in exchange. Whether that trade works out depends far more on whether somebody will keep the cron jobs running than on anything in the feature list.