First of all, I believe all 94 production was Generation I.
So you can breathe a little easier.

Is this not a transverse mounted engine??? If it is, then the
firewall area is not at the rear of the engine..It is at the side.
The rear of the engine (where the main crankshaft seal is
located) would be toward the drivers side fender well.

At any rate, you seem to be leaking something onto the
exhaust headers or exhaust pipe.  You should be able to
smell the difference between coolant and oil.  Remember that
there are other fluids that could leak occasionally in that
area: (1) windshield washer fluid, (2) brake fluid, (3) power
steering fluid, and maybe even (4) transmission fluid could
conceivable contact the hot exhaust.  Another wild possibility
is that you have a leak in your air conditioning system and
the lubricant is dripping on a hotspot. (Later model R134a
refrigerant systems use PAG [polyalkyleneglycol] lubricants
which smell  like coolant or brake fluid.  PAGs are not oil based)

Now, are you losing any of the fluids mentioned??? Could take
you a time to notice it, because very small leaks can put out
a lot of 'smoke'

A rear main seal will allow oil to drip into the tranny bellhousing
area, and bad valve cover gaskets will allow an oil drip higher up
on the engine.  Either of these could conceivably get on an
exhaust pipe, but you would smell the oil smoke.