On a Macbook, natural scrolling feels right on the touchpad. The real crime is not having a separate setting for a mouse. I had to use applescript tied to a keybind so I can use natural scrolling on the touchpad and toggle to regular scrolling when using a mouse wheel.
Another recommendation is LinearMouse. It lets you fix pretty much every problem that MacOS inflicts on mouse users: pointer acceleration, scroll behavior, click/button behavior. This and Karabiner make the OS much more usable for me.
Check out Scroll Reverser; it's a tiny, open source app that solves exactly this.
There are some other alternatives like BetterTouchTool if you want some other changes like gestures, but as far as this specific problem goes you can just `brew install scroll-reverser`, set up the settings you want and forget about it. Life is too short to deal with this nonsense which is clearly designed to sell the Magic Mouse.
I love Macbook trackpads, even use a Magic Trackpad at my desk, and "natural" scrolling has never felt right for me.
I suspect my mental model is locked into the "drag scrollbar handle down" mode from the early mouse era rather than "drag page up" mode that is intuitive to people who's first computing device had a touchscreen.