I've recently dealt with Red Gate's support team for a minor issue I was having (I couldn't find my serial number), and I honestly can't remember the last time I've had such a good experience with any support anywhere. They even followed up with an email a few days later.
They seem like a really stand-up bunch of people (and I really like SQL Compare as well).
I'll second that. I purchased one of Red Gate's flagship products (ANTS Profiler) about a year ago to use on one of my last projects for school (a .NET-based numerical library), and I remember thinking that they were the first company that had ever made me think, "Their customer service is so good, I'll definitely buy something from them again."
They seem like a really stand-up bunch of people (and I really like SQL Compare as well).