Introduction: The end of the coronavirus disease 2019 (COVID-19) pandemic has been declared by the World Health Organization on May 5, 2023. Several vaccines were developed, and new data is being published about their effectiveness. However, the clinical trials for the vaccines were performed before the Omicron variant appeared and there are population groups where vaccine effectiveness still needs to be tested. The overarching goal of the present study was to analyze the effects of COVID-19 vaccination before and after the Omicron variant in patients considering comorbidities in a population from Nuevo Leon, Mexico. Methods: Epidemiological COVID-19 data from the Mexican Social Security Institute were collected from 67 hospitals located in northeastern Mexico, from July 2020 to May 2023, and a total of 669,393 cases were compiled, 255,819 reported a SARS-CoV-2 positive reverse transcription quantitative polymerase chain reaction (RT-qPCR) test or a positive COVID-19 antigen rapid test. Results: Before Omicron (BO, 2020-2021), after 14 days of two doses of COVID-19 vaccine, BNT162b2 and ChAdOx1 vaccines were effective against infection in non-comorbid and all comorbid subgroups, whereas after Omicron (AO, 2022- 2023) there was no significant effectiveness against infection with none of the vaccines. Regarding hospitalization BO, BNT162b2, ChAdOx1, CoronaVac and mRNA-1273 significantly protected non-comorbid patients whereas BNT162b2, ChAdOx1, and mRNA-1273, protected all comorbid subgroups against hospitalization. AO, BNT162b2, ChAdOx1, CoronaVac and mRNA-1273 were effective against hospitalization in non-comorbid patients whereas for most comorbid subgroups BNT162b2, ChAdOx1 and CoronaVac were effective against hospitalization. Non-comorbid patients were protected against death as an outcome of COVID-19 during the BO period with most vaccines whereas a reduction in effectiveness was observed AO with mRNA-1273 vaccines in patients with hypertension, and diabetes mellitus. Discussion: BO, COVID-19 vaccines were effective against infection, hospitalization, and death whereas AO, COVID-19 vaccines failed to protect the population from COVID-19 infection. A varying effectiveness against hospitalization and death is observed AO.