Will Ferrell and John C. Reilly are both funny men. They are funny together and they are funny separately. Spoofs can be very funny. Sherlock Holmes is a character ready to be spoofed (and he has been spoofed before).
That said, these two funny men with what could be a very funny idea for a movie end up delivering something... less than funny in "Holmes & Watson."