For medium to large projects, SPA or not basically boils down to the question where you want to manage the state and logic, is it at frontend(SPA) or backend(MVC,CRUD,etc), you still have to do that somewhere with complexity.
If the website is simple then definitely no SPA is needed, either htmx or alpinejs or vanilla can get the job done.