The title pretty much says it! I’d like to explore that idea a little and would love to hear y’all’s recommendations. This thought was originally inspired by lord of the rings, but I’m also currently on a little nostalgia trip by reading The Sea of Trolls and the soft magic system in that is pretty fun
The Priory of the Orange Tree might fit what you are looking for. I’ve only learned the term soft magic just now so I might be wrong but magic in that world is mysterious and feels similar to Lord of the Rings. However there’s multiple types of magic and one of the main characters understands a bit more about one of those types and thus knows a bit about its limitations iirc so we as the reader are introduced to those a bit. Overall I’d say it probably fits.