Which book or books discuss IT application architecture across different tech stacks and in a concrete fashion?

I'm a teacher, and I can't find any books discussing this topic in a concrete fashion. They are all general and academic. I am looking for books describing several technology stacks and talking about what choices there are designing an application in each stack.

For instance, given a Microsoft stack with SQL Server and ASP.NET Core WebAPI and a frontend in any of the main SPA-frameworks, for instance Vue.js - what options are there in designing this web application?

Why would I choose to use Domain Driven Development? Why should I make a layered application? Should I use the repository pattern or not? What are other options? Why should I not simple let SQL Server return JSON directly - it would be ready to be consumed by the frontend. Should I use microservices? Inversion of control?

Of course some of these questions may be answered in general - and not in a given context of a technology stack, but some of the stacks have typical application architectures.

I am not asking what book is best. I simply cannot find any books like this, so I am asking for any books that cover any part of what I am asking for.