I have perhaps been one of the most prolific "critics" of Scottish tuning here on the forum. As someone who was brought up in Lanarkshire I heard a lot of Scottish accordions, particularly in the 50s and 60s, and people definitely got a buzz when an accordionist began a tune with one of those big intro chords that are part of the Scottish playing style. I liken it to the sound of the bagpipes, but I'm not very keen on them either.
When I finally got round to playing in the 80s, I chose French musette on CBA, largely because of the very strong sounding three voice musette boxes most of the big name French players used. As it turned out it wouldn't have mattered what style of music I chose, as I never really managed to make the grade as a player, due to starting too late. I can crucify a handful of French musette standards, but a severe hand injury put paid to any delusions of grandeur I may have had in the flushes of youth. I have explained elsewhere on the forum why I never opted to play Scottish, and I dare not go there again.
I found the more I listened I realised that a lot of French players had ditched the three voice musette in favour of a drier tuning, much as some of the Irish players are doing these days. I don't know much about Scottish and Irish music at all, but some of the French players wanted a jazzier or swing sound, and rejected the "musette pur" that once reigned supreme. As far back as the 30s some players were recording on single reeds with varying amounts of success. The quality of the amplification played its part, but the fact was that the French musette style began to split into two fairly distinct factions, which has continued to this day. In Italy, Maestro Davide Anzaghi, author of the famous method book, advised his pupils against buying a musette tuned instrument, as he reckoned the tuning was too limited in scope of musical styles. I once owned his book, and that comment sort of stuck with me.
I appreciate that no such split has happened in Scotland (yet), where very strong musette tuning has prevailed. I don't listen to much Scottish or Irish accordion music, but Tom Orr has a very different sound from the traditionalists. He has his critics, but his ability sells itself with his drier tuning. He also likes to embellish the tunes, which you'll appreciate is/was a strict taboo in Scottish accordion appreciation, as was playing anything other than strict tempo.
I do believe that it will be a very long time before Scottish music goes down the Irish route, if it ever does, but with today's almost obligatory requirement for players to be amplified, then the need for "Scottish tuning" may be up for debate.
I think it is all down to a matter of personal preference. I've heard one or two French players swinging tunes whilst playing three voice musette, and not many of them managed to cut it. By contrast I've never heard a Scottish player even attempt to do that. In my very limited experience of Scottish accordion music, it would seem to be the case that the audience and your fellow players expect the tunes to be played the way they always have been. If you dare to stray too far off the mark then you're snookered (unless your name happens to be Tom Orr!).
If I was to pick any three voice musette tuning it would be Italian. In my opinion it is the sweetest sounding three voice musette out there. For me, French three voice is too metallic, and Scottish is too heavy on my ear. Of the two Irish tunings I also prefer the drier version. It seems to allow players to be more adventurous with their playing.
It takes all sorts, as they say. Nothing wrong with Scottish music and tuning, for those who appreciate it. I probably wouldn't want to listen to Cajun boxes barking at me all night, but the local Louisiana folk love it. On the other hand I could listen to Brazilian guys playing all night and day, and they probably wouldn't know what to do with three voice musette.