Yeah, I feel much the same, there's something about Freud's painting that I can never quite put my finger on that gives it real presence and yes Bacon's another example, you can't ignore it but who'd want a screamimg pope above the fireplace?
We seem to have moved on from decorative art that can be used like that, I could live with a Pollock but it seems that now if a piece of art can be safely hung in a domestic environment it somehow degrades it.
Although maybe David Hockney's defied the trend