Rendering the marketing pages of the site -> HTML+CSS
Need to add the tiniest bit of interactivity -> jQuery
Have a "module" of functionality that -> SPA
I disagree. They are whole frameworks taking a completely different approach than jQuery, which is basically just a helper library.
jQuery is useful as a tool for operating within an externally organized application (or otherwise mostly static DOM tree). It simplifies low-level operations like DOM element manipulation.
Frameworks like React or Vue take a top-down, more declarative approach on how the DOM is built and updated. It's in many regards more powerful and more productive, but comes at a certain cost (setup complexity, total page size, certain aspects of performance).
So, which tool is best for your project really depends on the individual use case.
It ain't new and shiny but you can build anything with it. In fact, today jQuery is used on 97% of websites* while React and Vue are around 0.2%. I imagine that will change over time.
* Top 10M Alexa ranked: https://w3techs.com/technologies/overview/javascript_library...
Granted I've only deployed one SPA to prod and that was an Ember application but I'm not feeling the love based on that project.