In my opinion, vision 3 500T is the most flexible color film stock available. It can serve you well in low-light scenarios where additional iso is helpful, and can also look great on a sunny day without a filter. This is with the caveat that its flexibility mostly depends on proficiency in digital post-processing and correctly adjusting white balance to arrive at your final image. Some labs may put in the time to do this, others won't. There is a large contingent of people out there saying they "don't like the colors" of 500T to which I say they simply did not process it correctly. I am also in the camp that insists running it through the native ECN-2 developer gives a better result. It was not designed as a "daylight" film and the tendency to shift towards blue can give you washed out and/or color-shifted results under cooler lighting conditions. Of course, this could be desireable. This can be particuarly helpful while shooting at golden hour and wanting to keep the orange/yellow tones in check, as this is the color temperature it was designed for.
Cinestill 800T is the same film, but with some downsides. The lack of anti-halation is a no-go for some, others love the effect. There are also significant light leaks in many of the rolls I have seen, specifically in the first few frames. Whatever equipment they are using to remove the remjet or respool the original film is not completely light-tight. It also has a higher likelihood of sitting on un-refrigerated shelves and degrading. Cine film is designed to be cold stored, shot and developed as soon as possible.
If you are interested in trying this film without the halation effect I would suggest going for the original 500T (or perhaps the new AHU variant) and developing ECN-2. I realize this is less accessible, though. You can also develop the cinestill version in ECN-2.
I have shot over 100 rolls of the stuff over the past few years in just about every lighting scenario imaginable. It took some getting used to, but it is still my go-to film for most scenarios. If you want to shoot low-light scenes or don't mind a slight cooling effect it's a no-brainer.