At the beginning of this year I started a website to collect these items. It hasn't been active - except for the forum, which has been invaded by spammers.
If you have a product that fits this description - it does the job but has weird flaws that suggest nobody checked it out - submit it! Go to http://www.nottestedintherealworld.com.
Maybe I should have some sort of contest. I do have a "product of the month" but there haven't been any entries.