I have used both US-05 and S-04 in an Irish Red. Cant say which one I liked better but both worked well for what I had in mind. I could also see Nottingham and Bry-97 working just fine as well. The choice might come down to fermentation temp, recipe, etc. Each yeast will have slightly different characteristics but all are clean, fairly nuetral strains.
As far as the K-97 I have used it only 3 times and was happy with the results. There was a signature character with the yeast but I couldnt quite put my finger on it. I do not remember thinking it was tart or sour in particular. Maybe some sulfur but nothing offensive. I have used it between 58-64 mostly being around 62*. I wonder if its a pitch rate thing?