Am I wrong to believe than in order for a good song to be good & a good sound to be produced it has to have a amazing or good music writing?
No
I don't like it because when I transfers my Chords or melody to say a synth say Serum or Massive, or Spire they don't sound as eloquent or as nice as they do on piano
Could you give us an Mp3? I write all my music on piano and I've never had any problems getting chords to sound just as eloquent with electronic instruments.
I don't like using presets because I don't feel it to be me who did the hard work so then I make my own sound but when I do the sound either because abysmal or not good enough
There's nothing wrong with using presets. Screw hard work. Focus on efficiency. If you can crank out a good patch in 2 minutes using a preset then why not use it?
Am I focusing too much on writing a good song that actually designing?
I don't know. You should focus on both. Sound design is a part of writing a good song.
Do I lack knowledge in harmonics?
I mean... that's not something we can really answer without being you. Dance music instrumentation DOES involve sounds with different harmonics but you don't need to understand any of that technical stuff to know whether a sound is good or not.
Should I spend not 80 percent of my time on writing? Instead put it in like kicks snares, mixing & sound design?
Do what inspires you. If you wanna spend 12 hours tweaking a synth then you should do that. Ultimately though, the average music consumer doesn't care about how many sounds you can make. It's the music that you're able to create with those sounds that really matters.
So would you say my problems is writing which leads to a bad sound? 'cause I see some people write then transfer and it sounds great but I just can't seem to do it for example I'll post the link to guy who writes and transfers to what seems to me very easy
It's very hard to say what the "problem" is without hearing an mp3. Even if your music sounds good on a piano it can still sound bad if it isn't mixed correctly.