With 10M testers with atDNA and public access via GEDMATCH, dozens of law enforcement agencies in the US are using this source with amazing results for cold cases and unidentified remains.
YDNA has much more long term promise as the tree of mankind is adding dozens of branches daily now in the genetic genealogy databases. With around 1,000,000 public YSTR testers and over 50,000 of NGS testers, administrators of FTDNA haplogroup projects can give you the probabilties of surname for 10 to 30 % of testers depending on how prolific each genetic cluster is - just on YSNP testing.
Many surname clusters (those related since surnames were first used around 1000 AD) are around 30 % of my testers in my haplogroup project R-L226 (which has around 1,100 testers and is 90 % Irish). We are now assigning YSTR/YSNP mutations to ancestors on our pedigree charts on a regular basis these days. For example, if you test positive for the YSNP FGC5639, there is a 90 % chance that your surname is Casey and they you descend from two or three Casey men that arrived in South Carolina in the 1750s. At least 75 % of the Caseys that live in the southern states belong to this surname cluster. There are two known NPE lines (adoption of Casey males by non-Casey males - Hanvey & Meredith.
The ability to connect testers together is all about sample sizes of the testers. This database is not limited for the US and has extensive western European content as well. The databases, adhoc tools, and skill levels of the administrators is very high (there is an excellent mix of academic, genetic, math (probably the most important) and technical skills.
The problem with most law enforcement and academic databases are the size and scope are very limited when compared to genetic genealogy databases. The bulk of the YDNA database is under terms and conditions of the Family Tree DNA web site rules. But most of this database is also in the public domain as well which is not subject to FTDNA web site terms & conditions usage.