I don't use them often but if I'm walking around and someone wants me to open a url on my phone for any reason (billboard, ad, store, restaurant, anything in print) then it better be really short or have the QR code right there for me to even think of bothering.
Still that means I probably use one maybe twice a month, but I would use them more if they were more widespread.
I expect most people are the same, no one types long URLs into their phones while reading them off a newspaper or billboard or store window do they?