I prefer my Manhattans served "Sweet", or "Perfect " at a push. The Manhattan is complex, challenging and moreish. Best of all, it's available in a style...
Don’t have any Chambord but I sometimes swap in my favourite lingonberry liqueur for the sweet element in a cocktail and it generally comes out well. So similar idea I’m guessing. Have you tried the Cherry Manhattan also on diffords? Can recommend!