I skipped FoD at release due to those poor reviews. A couple of years later, during a painful bout of RPG withdrawal, I found it in a bargain bin and was pleasantly surprised. It was much more engaging than what little I'd played of Wasteland, and like bjon045 said, it likely benefited from its shorter length. After all of these years, I still remember those killer clowns!
Originally intended as a Wasteland sequel, EA dropped references to Wasteland after a dispute over the IP when Brian Fargo's Interplay broke from EA to publish their own games. EA finished the game with a different team and development was likely cut short. A few years later, Interplay released their spiritual sequel to Wasteland and called it Fallout.
Due to its rarity and connection with the Fallout and Wasteland series, FoD has become a sought-after collector's item. EA released them in small flimsy boxes that were easily crushed, and I doubt many stood the test of time. I'm lucky to have a sealed uncrushed copy of Fountain of Dreams in my collection.