Typically Dad gets a tie and if he's lucky is left alone to get some private time to a hobby (which you never get enough of with kids), or a BBQ in the afternoon. Not quite the big deal for Dad's as it is Mom's.
For me, I'll still make breakfast today, still clean up today, not much different than any other Sunday really. Perhaps when the kids (3 and 5) get older that will change.