I've never heard an actual human express noticing or caring about the color of the bubble.
I often get people trying to send me videos or files via SMS (I have an Android, and I guess it normally works for them when sending to other Apple users).
(I say adults, because I often hear kids use it as a status symbol or way to exclude other kids from group messages. I will have to ask the kids I work with what they think about message color bubbles.)