IMO, turbo is great for smaller engines, to get that extra "umph". The main draw back tho, is what is known as Turbo Lag, it will not give immediate boost from engine idle, also your turbo cannot continuously out put, it needs to cool/regen. Hence the invention of the turbo cooler. Many cars now have them built in, but back in the days they were an add on, and pretty much a must if you were doing any kind of performance driving. One may not really notice turbolag as much if its just daily green light rocketing and then normal diving after that. As far a Superchargers go, now if you have some decent HP and you just want it to ROAR, well this is your option, but lets just say your car will no longer be a fuel effecient commuter :-0
Main difference between the two is a supercharger is a big pump that is driven by belts or gears from the engine and can be felt almost instantly, whereas a turbocharger is a pump driven by a turbine driven by the exhaust gases of the engine. Due to the nature of a turbo charger, it will not give immediate boost from engine idle. It takes time to act. A turbo is the easier to fit, if one is retorfitting it.
Great information.