> t having watched the movies and talked to my son who has read the books a few times, the magic system seems entirely inconsistent and capricious,

I agree. The magic in Harry Potter is used almost purely as plot armor.

Why does this $MAGIC work but not that $MAGIC? Because the plot requires it.

It's not a good example of universe building at all. The approach in the discworld novels is a lot better.