I'm one to hold out for HD versions myself, but you might be surprised how good the SD version looks on DVD. Your results may vary depending on what your setup is like though.
I'm sure there's an audience out there that have either never heard of Dexter before, or don't have Showtime. I'm a big Dexter fan myself and will be tuning in to see just how the edits are done.