Connection machine = only had one customer afaik (NSA)
Transmeta - interesting technology but nobody in that market wanted to run anything besides Windows+x86.