In terms of effect, all the yeasts do the same thing. They eat the sugar in flour and produce carbon dioxide and alcohol.
With dried and fresh yeast, you get consistency - if all your variables are the same (same type and weight of flour, water, salt and temp) a given weight of yeast will produce a risen dough in the same amount of time.
A starter has its own set of variables that need to be carefully managed if you want to achieve consistent results and so adds either extra complexity (if you're going to get into managing it properly), or a level of uncertainty to the end result (if you just whack it in and hope for the best).
However, the main thing a starter does that other types of yeast don't, is add extra complexity of flavour - no matter how well you manage it, it's going to change the flavour of the end result in a way you wouldn't get without it.
When you make any bread, it undergoes a period of fermentation, enzymes in the flour are getting to work breaking down proteins and releasing sugars, the yeast is feeding on those sugars and producing CO2 and alcohol. The longer the fermentation goes on, the more sugar will be eaten by the yeast and the more alcohol will be produced. The more sugars left in the dough after fermentation, the more complex, nutty flavours will be present in the final bread.
So fermentation is a bit of a balancing act between leaving the dough long enough for the enzymes to bring out those complex nutty flavours but not leaving it so long that the yeast eats all the sugar and produces so much alcohol that your bread is inedibly sour.
A starter basically allows you to pre-ferment a bit of flour (or a mixture of flours, each bringing their own complex flavours to the party) and, if properly managed, it allows you to add a whole load of additional complex flavours into a dough that, if left to its own devices, would become inedibly sour before it was able to develop similar complexity. The danger is, if you don't manage your starter correctly, it will get incredibly sour and might end up ruining your final bread.
Personally, I prefer long fermentation using dried yeast over messing about with starters as I like a nuttier tasting bread, rather than sourdough.
TLDR: This has become way longer than I intended but essentially, yeast is yeast - dried/fresh yeast give you consistent results, starters give you a headstart on flavour but with potentially uncertain results.