One thing to consider at least for Clinical Psychology programs is that many people who go the tenure-track route complete not just an internship but also a postdoc. Thus, you have two more opportunities to add the prestige element to your vita. Going to an average doctoral program with the right mentor and fit may end up with you being happier and more productive in the long run. This will be key to being competitive for internship and beyond. Sometimes the people who are most successful on the job market and who stand out when it comes time to review applications for TT positions are people who went to the programs that aren't typically thought of as prestigious. There is something to be said for people who can demonstrate upward mobility and generate sound science despite having fewer resources. Just some things to consider when weighing the prestige of a school with fit and mentorship.