The Reddit r/MusicTheory guide on musical modes made it click in a way that none of the other 50 sites I visited could do. I know it's just a silly website (a subreddit at that) and not a big sexy book or course but good educational material on modes seems to be in short supply these days.

https://www.reddit.com/r/musictheory/wiki/core/modes/