I had no problems either, until we hit peaks. We hit our problems at about 7 million unique logins per month, we do not track visits in the same way. I am not that invested in Matomo and it just costs time for me.
I am not sure how you scale Matomo we could not vertically scale anymore, we never did MySQL clusters because it just was not cost efficient for internal reasons.