The regular 200 and 250 models aren't going to really have any distinctive exhaust note apart from regular engine noise. It does have a tad bit of turbo rumble but not much. THe diesels should sound like any other mercedes diesel (not that great)
Here is a video of the exhaust note from the A250 AMG which should have a very similar drivetrain to the CLA250