"Sopranos better tv show because it is not a fantasy tv series" - are u trying to say, that fantasy tv series is bad/worse? then its ur opinion. like you would say rap is better than pop. one likes pop, one likes rap.
"It doesn’t feature dumb plot twists" - there are no dumb plot twists, many episodes in seasons 1-6 were basically actors talking to each other, to avoid misunderstangings in plot twists.
"it doesn’t feature any dumb and unnecessary deaths" - which death for you was dumb or unnecessary? i think (not sure cuz i dont remember every death in GoT) that i would be able to tell you with logic way why did this person died or not. everything was logic until season 7 and 8.
"it doesn’t feature the dumbest writing in the history of television" - as above, 1-6 seasons are with perfect writing, nobody had any word bad to that. nobody.
"doesn’t have irrational flying dragons" - alo? its fantasy? and that book is about dragons?
"nobody cares about special effects/cgi/music" - ofc you care, except good writing, plot/story you need to see this in good quality production, because with your logic Rick & Morty or Simpsons = Game of Thrones/other series you think is top1, just because nobody cares about special effects/cgi/music. These 3 things (special effects/cgi/music) builds in you tension in plot twists moments, action, etc.
"Conclusion: Sopranos is a better tv show than GoT. The Wire is better." - you didnt say anything other about these two series other than: "Sopranos better tv show because its not a fantasy tv series" which is just your opinion. Nothing else, no arguments.