Coda, though that's being replaced by something new
any minute now.
Apple News, though it's still moist behind the ears and needs more features.
Sequel Pro, though if there's a Windows equivalent my IT department hasn't found it yet.
There are a bunch of tiny workhorse utilities like FileChute, EasyBatchPhoto, and Subler. Though there's probably a Windows version of Subler.
There are a number of Mac-only apps that attract people, but it's not the 1990's anymore. People don't use a platform for a "killer app." Most people choose a computer because they like the way it works. macOS works better for a lot of people than Windows or Linux. They may also be partial to the hardware for various reasons.
They all seem to try and follow Apple’s model of only serving the happy path
Apple, and its users focus on getting things done. Productivity is highly valued.
completely ignoring anyone who needs more than that - e.g. power users.
"Power users" is just Nerd for "tweakers and hobbyists." Apple hasn't been interested in that demographic since 1984. If you're a later-day "power user," good for you. Linux awaits.
The only reason I keep a Windows box around is for IE11 compatibility testing. And Linux I only use on servers. That's because the way macOS works makes sense to me. It didn't at first, coming from Windows. But now that I understand the workflow conventions, it makes sense, and I prefer it.