Many good points here. With C41 at least you have options - darkroom enlargement or scan, but with E6 slide there's not much. Both films have their usable fields. For landscape I just love slide films, for people I shoot color negatives.
Now, when the mighty Cibachrome is gone, the bottom line is how you scan your slides.
I always got goosebumps when looking my slides against the light table, but most shooters I know aren't mostly satisfied with the scans viewing them through the computer. It's nowehere near as good as viewing them with your own eyes.
Widely used consumer and prosumer scanners just don't take the "juice" out of them and if you want to score anywhere near only the very good prosumer scanners do with VERY good operator, or if you want the "real thing", only the high-end scanners with a skilled operator will do the trick IMO.