Nope. For many to most programs, no one has likely heard of them. Most psych programs are regional by nature and/or design and most aren't "low tier." You will also get loud talking heads on the squak box and social media from programs assumed to be good because their basketball team does well. And some of the truly bottom tier programs are so malignant that they are infamous and more familiar by name than many solid regional programs.
There are a list of about 10 programs most folks would probably agree are amongst the best in the nation and about 5 folks would probably agree are amongst the worst. Between them is a spectrum. But what's handy that along most of that spectrum are some programs that will give you quality training and allow you to be an excellent psychiatrist. Even though you've probably never heard of many of them.