Well, we know that TomTom will be building hardware that assists the iPhone's GPS into their cradle/dash mount, so what does that tell you?
On it's on, it's decently reliable. But it won't replace your in-car unit by itself.
For daily activities, walking around, etc., the compass will certainly help out quite a bit.