I'm a lawyer, and as such my favorite answer is "it depends." Like stated above, there could be jurisdictional differences. Here in Florida most people when buying a house just handle closing and escrow through the title company. That's great, so long as there is nothing wrong on title and you've confirmed that your property isn't in violation of any local ordinances, etc. I've seen brand new homes in platted neighborhoods with HOAs have a massive easement covering almost the entire property, I've seen new homes built in violation of local approvals (size, or setback, etc.).
There is a whole parade of horribles which you can encounter if you don't have either a lawyer, a ton of experience, or both. Will you encounter them? Likely no. Will your house catch on fire? Also, likely no. But insurance is still a good idea just in case. Also, I'm not a small-firm real estate lawyer with a title shop who closes home sales so I have no dog in this fight--I work with big developers and builders to develop large communities, I've just seen so many issues large and small that needed a lawyer to either discover, recognize or correct.
A personal favorite was on a smaller parcel with some RV's on it that was ultimately going to get redeveloped: seller didn't know, and title didn't show, that there was an old private railroad line bisecting the property. The company that owned the line went out of business years ago, and the track was gone. It didn't show up in title because it was so old that the 30 plus year old legal description for the property actually carved out the track, but the property appraiser's office didn't show that carve-out. The deal died because seller couldn't fix the problem, which they kept insisting wasn't a problem. If my client would have bought the site they could have never built on it.