I've only driven it with the adaptive suspension, but I can tell the difference between comfort and dynamic is significant. If you're gonna use it as a daily, I'd recommend the adaptive suspension. The regular one must handle even the track driving so I figure it can't be nowhere near as comfortable as the adaptive one set in comfort mode. But I must admit I have no idea how big the difference is in the prices - it's easy for me to recommend the adaptive one since we have it as standard... at least, because the car is insanely expensive to begin with.
Would be interesting to hear how big the difference really is, if somebody's driven them both.