Honda sometimes missed the mark on intended market also. The Element (I had a 2003 and now own a 2009 with only 65k on it), was targeted towards surfers and sailboarder types, hence the rear sunroof to allow changing while standing. The buyers ended up being mostly middle aged sierra club types lol. I love mine for its utilitarian design (just make sure the muzzle brake of your woodchuck gun is out of the rear cargo area when lying in the back). It could use more power as passing on a two lane is an exercise in timing!
Another cool little car was the CRX-SI especially the 88-91 models. Yet another car that because it was a 2 seater, most young people couldn’t afford the insurance because most carriers classified all of them as “sports cars”.