The best one I remember was in New Orleans when I was a LEO. Two guys broke into a drugstore and were looking for morphine so they could shoot up. What they mistook for morphine, was novacaine... so when the drugstore opened, they found two guys lying in the floor who couldn't move their legs... which they had used to shoot up. When interrogated, one of them told the officers that they had not been getting "buzzed" so they kept injecting it over and over... and when it kicked in, they couldn't move their legs.
Their prison tattoos say "STUPID" right across their foreheads...