For trout fishing I only use fluoro these days and I swear by Seagur Grand Max Fluorocarbon. The smaller sizes are incredibly strong.

Other fluoro brands I like are Orvis Mirage and Varivas IF I can find it.

When I used mono it was Orvis Super Strong for years.

In regards to dry fly fishing, FWIW I actually prefer a sinking tippet for dry flies but regardless of material, most of it doesn't sink without coaxing or the use of Xink. I believe much of the flouro out there is treated to promote floating. When I do get it to sink I feel it is less visible than a floating tippet slicing the mirrored surface tension of a glassy pool. Whether the fish care is open to debate. A sinking tippet also hasn't had any effect on whether or not my fly floats highly and it doesn't pull it under as many would expect.

YMMV