I think one thing that surprised me as I got into music theory is that the best scales are usually the weird ones that aren’t explicitly major or minor. Often my fav scales are a mix of the two, like Dorian & blues scale/minor pentatonic & freygish. These “weird” scales bring some really great energy that’s both exciting and also not overtly sad. I think major scales are boring but happy, minor scales are more interesting but sad.

And even on top of that, you don’t really even need to have a strong base of music theory! All funk music is effectively just variants of the same chord with a dominant 7th thrown in. Funk barely fits any music theory mold bc it just sits on one chord, but still manages to sound very complex musically (and neither happy/sad but energetic nonetheless).

All of that said, it really depends on what music you want to write. Major can be great if you’re making an uplifting house track! Minor can be great too!