The poly resistor has a decent low TCR, and is quite linear, with a linear parasitic capacitance to the substrate (since sitting on SiO2). This makes it a prime candidate for analog design, however, required an extra mask, so sometimes not available if designing for cost.
N-well resistor is always available (as soon as there is a PMOS), but has a strong nonlinear parasitic cap (a reverse PN junction) to the substrate. However, since it sits in the substrate, thermal dissipation is good, which is the only downside (besides cost) of the poly resistor.
BTW, the silicided poly-resistor is always available when there is a PMOS/NMOS (with the exception of newer technologies with metal gates). What is usually meant is the silicide-blocked high-Rsquare (ca. 300Ohm/sq) poly resistor. The suppression of the silicide requires the extra mask, and often a higher Rsquare is also available (ca. 1-2kOhm/sq).