You are right, there is no specific SQL Server related certification path anymore! Everything is related to roles and no more technology => "Database Administrator" no more "SQL Server 2019"
To give you a perfect answer, you have to give us more information on what do you want to achive? Which role are you looking for?
For example, I answered this question some days ago...
https://learn.microsoft.com/en-us/answers/questions/918746/seeking-advice-from-microsoft-sql-server-dbas.html
Everything depends on your way ;-)
Do you want to become a Data scientist or Data Engnieer or Data(base) Administrator?
If you search for actual/active certification for SQL Server the only result will be DP-300
https://learn.microsoft.com/de-de/certifications/azure-database-administrator-associate/