What is a common mistake with eager, explicit, and lazy loading in Entity Framework Core?

Lazy loading in APIs can create N+1 queries and hidden database access during serialization. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.