My experience with K-97 has also led me to steer clear of it. I've used several "kolsch" (or german ale) yeasts over the years and this one is not for me. I don't get the "tart" very much, but perhaps it's overshadowed by the sulfur production of the strain (regular old high oxygen batches). The aroma I get reminds me of low tide or a brackish wetland smell. No bueno.
Edit: I also wouldn't pick US05 for an Irish red ale due to it's powdery nature; you gotta have really clear beer for the red color to be striking. Wyeast 1056, on the other hand, flocks and sediments really well, so I might choose it if I didn't have access to much else.