I've never tried it, but honestly, I don't think it would be worth it. It might be worth it for certain local businesses who offer services that people generally need - restaurants who leave delivery menus, auto places that leave coupons for oil changes, etc. I feel like your products (and most of the products on Etsy) are too specialized for randomly dropping off flyers at people's houses to be really effective. Also I think that people don't particularly like coming home to find random flyers stuck to their doors, so most of them would get thrown out anyway. If you distributed a ton of them, you might get a sale or two, but probably not enough to justify the cost of the printing.
If you really want to do a campaign like that, I think you should try to find a mailing list of people who are interested in home decor somehow. I'm not sure how you would go about that, but I know that there are people who sell mailing lists. Maybe you could talk to some local interior decorators and see if any of their clients might be interested in your products.