I've never purchased any properties from the tax delinquent list but I've had my fair share of accessing the database of all the properties that pay property taxes to the county. I personally like to get properties that are 2 or more years delinquent. It's usually every property you can imagine. Farms, Lots, Single families, Commercial zoned lots and buildings etc...
I think it's a great way to purchase properties from this list for 3 reasons, 1) some people are struggling to pay property taxes (cheaper purchase price) 2) it is a hot list because people might lose their property to the county 3) data to find tax delinquent properties is hard to access sometimes because it's dealing with complicated databases and county data, so less competition.
If you are super savvy you can find delinquent properties in an area that has changed zoning. Allowing you to purchase a delinquent single family home in a newly commercially zoned area.
These properties sometimes come with other liens from the city as well so just look out from that. In my experience this has been an hot bed list for infilled vacant residential lots.
Good luck hope this helps!