At the risk of derailing the thread:
To the extent you're implying that all Bush appointees must be one or the other, I think that's inaccurate. It is possible to be nominated because you're a well-qualified candidate with a generally conservative judicial philosophy without blindly following the demands of the religious right or being a patronage appointment.
That's not based on any faith (pardon the pun) in the Bush administration. Even if you assume that the Bush administration is out to appoint the most extreme theocratic judges possible, they do still have to get those nominees through the Senate. Qualifications do matter: see Myers, Harriet. In a moderate state like Pennsylvania, you just aren't going to find many Roy Moore clones to begin with, and you'd have a hard time getting them confirmed.
I think it's more general, and less meaningful, than that. I would define "activist judge" as "judge who makes a decision I disagree with." I think the term has become that bad. Nobody seems to have a good working definition of it, and nobody seems willing to stand up and say "yes, I'm an activist judge, what's wrong with that?" It's become a label you hang on judges with whom you disagree. Conservatives started the trend, but now liberals are getting into the act, too, decrying conservative judges as "activist."
Basically, just about everyone is against "activist judges," so it becomes a meaningless conversation. I compare it to "political correctness." Rarely do I see anyone defend "PC"; instead the argument becomes whether something is or is not PC. The term itself has become fairly useless.