Marc,
You can make SD look good on that monitor. Find a high-end consumer HDMI video scaler that has a DCDI scaling/deinterlacing chip. Or if you can find one with the Realta chip (which was designed by Teranex).
An interesting product is one from Gefen:
http://www.gefen.com/kvm/product.jsp?prod_id=4298
There are other products as well. A lot of home stereo receivers can do this.
This kind of product will make SD look very, very good on the Dell 24" or any other computer monitor. It's essentially the same process that the high-end Panasonic LCD pro monitors use (although those have been calibrated to display accurate NTSC colors).
The issue is whether or not you want it to look good. The broadcast monitor is supposed to be "What You See Is What You Get".
Sean