It can be fast to respond and easy to cache on pages where content doesn't change often. When they are actually created and how they are updated will depend on the framework and settings you use.
The choice of SSG, SSR, and client rendering takes into account data refresh, personalization, and deployment operating conditions. Even pre-generated pages are not guaranteed to be indexed if they have access restrictions or content issues.