I have tried the Dymo Rhino (industrial) tapes and Brother Tze industrial, and prefer the Brother. I have not tried others like Brady, nor labelers for general home/office use. Users may see the industrial products cost more, I think there is a reason. I have small bottles of alcohols with Dymo Rhino labels and have not seen any wear.
Be very careful about the tape material and adhesive descriptions, there are many. Some are meant to be removable, some permanent, some permanent for rough surfaces. There's vinyl, poylester, maybe others.
I have less problems with "flags" as shown by OP, but even the Brother tape recommended for wraparound cable marking has sometimes unfurled on me after a few years. Some people will put clear heatshrink over it, but that requires the cable end being free.
The printable heatshrink seems pretty expensive to me, I haven't tried it to test the durability. It also has limited sizes and colors.
Dymo Rhino thermal prints onto the top of the tape, where Brother Tze prints onto an intermediate layer which gets covered with another layer for protection, making it more wear resistant, and shinier. It's somewhat easier to rub off Dymo Rhino labels.