please explain to me the difference, not because im arguing but because i genuinely want to hear your personal rationale on why one is superior

Well, mystery fiction is about the mystery and detective fiction is about the detective which seems innocent enough but what you end up with is:

Mystery Fiction: a fun, suspenseful ride with at least somewhat engaging characters, where the reader is generally encouraged to guess at the ending based on knowing context clues that the detective may or may not have (most crime shows, but not all are like this) and I really enjoy it! I like getting into the mystery, watching the detective struggle and everything come together and seeing if I’m right at the end

Detective Fiction: a monument to how Great and Special the detective is (a la Sherlock Holmes and other variations like House). It’s not about us being able to figure it out. It’s about showing how much better the detective is than us or other people in their world. We might not even get the clues until the detective reveals them at the end, so it’s not about the mystery or even an enjoyable ride to the end as all you can do is get dragged along and wait for that AHA moment where the author deigns to tell you what’s Actually Going On

Bad. BORING. Also the characters are usually assholes.

I’ve just never found that kind of story-telling enjoyable because I actually like interacting with media I consume.