Great question. They are two very different ownership styles. Single family homes appeal to buyers to want the space, privacy and feel of being a true "homeowner". They often come with outdoor space in the form of a yard. In some neighborhoods in Brooklyn a private parking space is the norm for a single family house.
On the other side of the same coin, maintenance truly falls on your shoulders. You shovel your sidewalk, you repair/maintain and solely bear the cost of the roof, boiler and other mechanicals of the house. In a condo these costs are shared, you pay monthly common charges to keep up the property and have someone else clean and maintain the common areas and shovel your snow! If your boiler goes out in a condo each unit pays a portion of the cost. In a very small condo, which there are several of in Brooklyn, this cost is shared evenly by all the residents, sometimes in installments broken up over several months (this is called an "assessment").
Something to keep in mind if considering a 4-8 unit condo building is having an inspection done before going to contract. This will give you an idea of the current life-expectancy of the essentials: boiler, roof. I could go on and on with regard to tax implications and resale value but that all depends on your situation. If you'd like to discuss more or ask any other questions, please don't hesitate to reach out. Best of luck!