Yes, they are sweet and varied. There are Port style wines from Portugal, Tokay from Hungary, Ice-Wine from Germany and Sauternes from France. Usually the wines are paired with specific foods.
Dessert wines are sweeter than regular wines in general. A couple of the most famous types of dessert wine are Riesling and Gewurztraminer. These two kinds of wines can easily be found in your local liquor store.