Ignore people who say things like, ".......is not good for......." Blanket technical rules based on someone else's idea of what a proper picture is will not help you. Shoot some and see what happens! It is fun looking at the slides, and you can use the film to shoot anything you want. Ask any professional photographer since its invention.
Most of the attributes connected to transparencies are due more to the fact that they are a positive, and are often viewed directly as a piece of film. You have to compare real-world prints before you make such judgments about color, contrast, grain, etc. I think the reason so many people say that slides are so awesome is because they are seeing the film directly, with absolutely no compression/alteration of dynamic range or color or contrast introduced by the printing process. Look at a black and white neg on a light box, and you see at least as much dynamic range as, and probably more than, a color transparency.
The real question with transparencies nowadays is: Why? Why do you want them? What is your intended final product? What is your application? The choice of transparencies over negatives has less to do with the properties of the films than it has to do with your specific application. I am not saying you should not use them...just bringing up the point that they are really about "workflow" more than anything else (to use an overused and annoying modern word).
It used to be that transparencies were the preferred medium from which to make color prints for magazines, newspapers, leaflets, and other litho printing applications. The printer could take the transparency and work directly from it, rather than having to work from a print, so it was quicker and gave better-quality reproductions. Due to the fact that the printing process (and thus all the equipment that goes with it) is unnecessary, you are more-easily mobile with transparencies. All you need is a lab or all your film processing equipment. No enlarger, no paper chemicals, etc., and no having to print before showing people the pix. They quickly and relatively easily gave others a positive image to look at and judge. If you shot transparencies in anything other than a fine art application where photographic prints were needed, you would not print anything yourself, but deliver the transparency to your client or to a litho printer.
...or have a slideshow on the wall!