I happen to find Tom Cruise somewhat attractive, despite the fact that I think most of his views are loony to the point of being ridiculous. I think he's enough of a nut that it would give me pause. However, I have to admit that if he showed up at my door asking for a night with me, I'd be tempted, and I would expect my husband to understand. There's a particular scene in Interview with a Vampire (the film, though I did read the book first) that has stayed with me a long time and influenced who I am sexually.
The same is true of Johnny Depp, though I think he is a little less crazy (and therefore more tempting.)
My husband and I often have these discussions. I find it interesting to see which celebrities make his hot list. I wouldn't change who I am to suit his tastes, though. It just lets me know more about him as a person.