I've completed all my doctoral training in NYC (externships, internships, postdoc), and worked in 4 of the 5 Burroughs. There are plenty of reputable programs here that will lead you to fruitful careers. Sure, you may not be working with Edna Foa, but there are plenty of researchers here who are doing novel and interesting work (I have been two degrees off from Aaron Beck throughout my training, meaning two of my mentors were trained by him; and actually, two degrees of separation from Foa, too).
NYC is also welcoming to clinical/theoretical orientations. I like to say that I got a firm base in psychodynamics but work with more cognitive behavioral psychotherapies now. And my psychodynamic background is solid for case conceptualizations, and certainly for building a therapeutic alliance, which makes service delivery work quite well. I'm generally confident that my research participants and/or patients will adhere to the full treatment protocols, and I attribute much of that to keenly understanding the complexity of each individual, and then, the confidence to believe I can truly help in whatever way the patient & I decide. (I owe that confidence to my training, as I'm sure others have similar feelings for their programs.)
One of my supervisors (who is an analyst, and treated one of Freud's former patients...REALLY. All parties involved are now elderly or deceased) says that "psychodynamics permits you know the patient, not the diagnosis." I think this is a helpful perspective, and as long as you're open to other opinions/orientations in training, you'll discover what suits you best. In NYC, through placements sites, fellow colleagues, multicultural/diverse populations served, you can't really beat the training...unless you're already super-focused and land one of those top tier programs in another geographically location...and after then, I'm sure the experiences are comparable, as we meet in the middle with those folks, too, at some points in practice.
Oh! And I recommend staying away from or really understanding what you're getting into with the New School (they have great researchers, but look at the average time for completion of the doctoral degree...it's ridiculously longer than it needs to be - and I've heard less than positive stuff about them accepting applicants into the masters program but declining them to go further into the doctoral programs...seems like their pattern). Check out the internship match rates, and definitely do not settle for a non-APA approved program...most in NYC are already, so are the training sites.
Good luck!
Edit: My point of the
gauche name dropping (kudos for me...I know, I know) is that here in NYC, you can be exposed to high-levels of training from multiple pioneers. And it's quite fun to read a seminal text, and then, have that author present at your program's colloquium, or you make a fool of yourself to introduce yourself to Otto Kernberg at grand rounds. Gives context and makes things a little more exciting.
So to answer your question:
@newyork-3, No, you will not be looked down upon; likely contrariwise, you may be elevated by training here in the city due to your multiple points of contact. And we don't have any online programs that I know of, and the for-profit, expensive/no funding programs clearly state this on their websites...so you'll know where you get a full-ride scholarship versus $180K in debt (most programs here are in between). Also, when looking up Teacher's College, note that it's a counseling psych doctorate, so here you also have the option of pursing PhDs, PsyDs in both counseling and clinical psychology (CUNY has several non-clinical doctorates in psychology, like experimental, etc.). You can search old SDN threads for lists of NYC programs, and even discussions about differences between PhD & PsyD (hint: both degrees are similar if the programs are reputable), and counseling vs. clinical programs (also, quite similar with nuances in training and populations served). Hope this helps.