It really depends on the use case- if I'm navigating my banking website, I would prefer a longer load time up front if it made it navigating between accounts really fast. If I'm checking my power bill, I'm probably only going to view one page so I just want it loaded ASAP
If the app has optimistic updates, actions may even feel instant.
If your app really cares, it'll have an offline mode/be local-first. Then you you pretty much need an SPA or some kind of heavier front end.
Also this is assuming, that one does not want to take all the things of that website and burn them after use, which is not a safe assumption to make on most websites, considering all the ads and trackers on today's typical websites.
An offline still working app sounds great. Unfortunately very few aspire to reach that point. Most already break to various degrees when you hit the back button.
But I'm specifically talking about users on slow links. They often know they don't have a first class connection out, and have established a different set of expectations.
If your site is actually good enough to be one the users return to (and who here wants to build a site where that's not the case?), they all appreciate the site loading very fast the next time.
Don't you think the case can be made against SPA's w.r.t slow networks ?
Angular, react add hundreds of KB's to frontend bundle which give bad UX especially in slow networks