Flickseeker lets you search thousands of movies by their mood. For example, here is a list of charming movies that are also funny.
A caveat: you can only search by what they consider "compatible" terms. There's no such thing as a whimsical + violent movie.