I guess I'm a fan of the principle of least surprise.
I'd far rather explicitly define a configuration property in some file than "if you create an environment variable called FOO_CONFIG_X=5, the Foo framework will populate your settings for you!"
Because when the Foo framework doesn't respond to your incantations the way the docs say it should, then you're going to spend the rest of the day reading code to figure out why.
Shit, the Spring annotation magic made me miss XML context files for that reason, the XML made wiring explicit, as opposed to auto wiring annotations that failed deep in the bowels of the beast.
It's a continual problem across languages and frameworks, the (admittedly very) convenient magic is great until it isn't.
I've lost enough time on it in my career that these days the only dependency injection libraries I'll consider for a new project have to be compile time.
Still as much magic, possibly even more (trying to understand Quarkus' compile time DI library ArC is... something), but at least it breaks before you can deploy it.
But it's a bit early in the evening for reductio ad absurdum.
After all, we can take it further into absurdity, why aren't we all just programming in hex via a keypad?
Abstraction != magic.
The one bit of SICP that really stuck in my brain was
"Programs must be written for people to read, and only incidentally for machines to execute"
Magic makes the first part far harder. And I apply this to every kind of magic in code.
Annotations in Java frameworks (I've had so much fun with Spring proxy invocations over RPC), monkey patching and metaprogramming in dynamic languages (or as Zed Shaw referred to it in Ruby, chainsaw infanticide) ...looking at you Django...
I like it when I can read your code after you've moved onto another company and understand what the code is doing and why.
I've used "memoizing intermediate steps" often in the past, but it doesn't need to be magic.