The usefulness of Y-DNA testing is dependent on many factors, including family origins, accuracy and completeness of one's family tree, the accuracy and completeness of others' trees, etc. For me, Y DNA testing has been critical. My father's family can be traced back to early 18th century in Pennsylvania, Virginia, and North Carolina, prior to moving on to Tennessee and other areas. I took a Y DNA test when it first became available publicly and later took an autosomal test with Ancestry. Ancestry remains my preferred provider because of the sizes of both their DNA and records databases. I do use several other providers, for example MyHeritage for their DNA segments analysis. The size of the Ancestry DNA database, coupled with the chronology and geography of my family origins, led to a number of false positives in my autosomal data. I identified the false positives, or ambiguous results, when I discovered alternate bloodlines while analyzing autosomal data and family trees. Over time, my Y-DNA results have become increasingly valuable for identifying and confirming my surname line. For example, I had found autosomal matches pointing to two other well-known George lines, which I have been able to eliminate through a comparison of Y-DNA test results. My greatest success came through the use of both autosomal and Y-DNA testing. Several years ago, I found a growing number of autosomal matches that converged on Edward George ( - 1737), a Quaker who had removed from Llangurig, Montgomeryshire, Wales, to Radnor, Pennsylvania, about 1710. I order to verify the autosomal results, a relative of one of my autosomal matches took a Y-DNA test and we turned out to be a close match. We have since, along with others, taken a Big Y 700 test, which has further confirmed our line, Lineage 2 in FTDNA's George Y-DNA Surname Project. We do not yet have enough Big Y testers in Lineage 2 to identify branching in detail, but some other lineage groups with more testers are getting good results. , In my situation, the use of Y DNA tests in conjunction with autosomal testing and traditional research has proven to be a key factor in braking down brick walls.
Unless one is absolutely sure of their surname line, starting out with a Y-37 test would probably be a good way to proceed. The results of a Y-37 would provide a good basis for future planning.