I started with slide film for studio work and used quite a bit. It's best shot using an incident flash meter and exposing for the highlights, which is pretty easy to do if you have a flash meter. If you do not have a meter, you'd want to use a digital camera as a substitute, and use an ISO setting on the camera that correlates well with the film you're using. The best thing is, the slide itself is the picture, so there's no intermediate step, like the printing of the negative, that some "other person" or "a machine" can screw up.
Color negative film is really great stuff, but the negatives have to be interpreted. When I was using gel-colored backgrounds, which was a common practice in the 80's and 90's, color prints could easily come back with odd skin tones unless they were custom printed with operator-override done...the large areas of background color (unexpected color) could fool the machines we had in those days...maybe the machine algorithms are much better today. But with slide film--YOU GOT what you had SHOT. And that's the best thing abut slide film on studio shooting: the film is developed to a rigid, known standard, and the film is the final image, without color interpretation, without a second step that can be messed up.
I would never suggest Velvia for people, unless it's Halloween.