i’m new at this, but i’m looking at the same thing… american music is in c; if you ever play with musicians who aren’t playing folk music (like me
they look at you weird if you try to play in another key…
a lot of the sheet music i have for Scottish songs is in g.
but the main thing is the sharps and naturals… if you’re trying to play with other musicians and just transposing the fingerings, it doesn’t seem to work very well (for me), because the sharps and naturals will all be off. i was trying to play “God Rest Ye Merry Gentlemen” with someone playing a harmonium (little piano they use in yoga studios) pitched in the key of c, but it didn’t work out so well… someone pointed out to me that they were starting on a c; the fingering i learned (for a d whistle) started off on an e (5 fingers down). so i switched to the c whistle. now i’m starting on a d. okay, one more, got it! picked up the Bb whistle, now i’m starting on a c with the same fingering, so i can use the same fingering i learned for playing the song on a d whistle.
the only problem is, the Bb whistle has 2 flats… so i sound off-pitch 1 note out of every 3 to the singer… argh. i tried half-holing, but it’s really hard to do that many (half-hole once every 3 notes!) so i’m reviewing my options…
one of which is to buy the g whistle; it would give me space to play the c scale and i’d only half to half-hole the one sharp (F) to stay in tune; the downside (beside still having to half-hole) is that i’d have to re-learn to finger the song. i’m not so worried about that though…
the other option i’m thinking is to just play the song on my c whistle. i’d have to move the fingering i learned down by one (not so hard) and i wouldn’t have to half-hole anything (no sharps or flats on a c whistle)… but to play the song that way, i need to be able to go down to a d so i’d have to move the whole song up an octave. i tried it today, hitting the 3rd octave e didn’t break any windows, but it’s pretty intense. 
anyway, the point is, unless you want to play a song with 3 sharps, i’d probably avoid the a whistle… although if you playing a d major song (2 sharps) what’s the difference between half-holing one sharp down on the a whistle or half-holing one sharp up with the g whistle (only F#)?
unless you like Scottish songs written in g anyway, or want to play american songs in c (you’d only have to half-hole down the one sharp, instead of 3 for the a whistle).
good luck and happy whistle buying! (what’s all this nonsense about choosing anyway, get them all! hah hah hah! 