There is a trade-off.
If you want more "depth", the dye needs to be somewhat transparent. IF it is transparent, you will be more likely to see the tube.
Opaque dyes will, by definition block each other, so you will see only the surface color. Also any "sparkle" inspired by a pearl or mica will be lost or at least heavily muted.
I am also not a fan of "painting". BUT, I like the look of the transparent blanks. So, when I turned LOTS of pens, I had a set of bushings that were made to fit the drilled hole WITHOUT the brass tubes. I would turn the pen very near final size and THEN slip the tube in (without glue) and decide what I wanted to do with the color.
I most certainly did NOT do this with most of my pens, I used the same blanks most of the time and knew what to expect. However, when I was making more expensive pens, with deeper, more elegant colors, the selling price justified more effort.
How good you want YOUR pens to look is up to you.
FWIW,
Ed