The Quad 4 was once hailed as the powerplant of the future, having the power of a V-8 while the effeciancy of a 4 cylinder. It turned out to be a problematic engine. Before GM worked out the issues with head-gaskets, the ignition system, and other misc. problems the engine had already earned a bad reputation. This is especially because of the single-overhead-cam version, which used a horrible amalgamation of parts and was the worst version of this engine ever made.
The shining redeption of the Quad 4 was its potential as a FWD performance powerplant. It helped Oldsmobile win many SCCA SOLO2 and ISMA competitions, and set a land speed record in the early 90's with the Oldsmobile Areotech. Many hot rodders and tuners thus choose to use the quad 4 because of its potential.
QUAD 4 simply means a 4 valve per cylinder 4 cylinder engine Oldsmobile produced, and GM put in various cars from 88~94.
A few facts: the QUAD4 was produced from 88~94. While a lot will still refer to the engine that replaced it as a QUAD4, it is not. It became the "Twin Cam". While I can't get into GM's Engineer's heads on the why, the fact you can not bolt a 95 right in where anything from 88~94 was is probably the main reason. Having said that, the basic engine was very much the same from 88~2002, which is why most people will refer to the any 2.3L or 2.4L in those years as a QUAD4. Why does it matter? Well the fact is when Olds (all the engines are Oldsmobile motors byt the way, regardless of the make its in) first made the motor, which was prior to the production model in 1988, they were making 750HP with a 2.2L version of it. (An Andretti drove the indy car it powered to more than 226mph laps at Indianapolis.)
So, for most of us what do we care? We care that we can get v8 power from a 4 cylinder with 4cyl economy when we can keep our foot out of it.
So, why does it get bashed all the time. Well like anything else there were some growing pains which did include some engine failures. More or less those problems have been resolved. Even in the older configurations the most significant issues have readily available fixes.
So, what should I look for? In a perfect world you would want a post 94 block mated to a pre 94 HO head...