I like realism, doesnt fuss me whether it'll last or not, i suspect thats down to the technique and talent of the artist, and the pigments used. Saying that If I got the chance to get some work done by Mr Devries or Mr Porter, I think I would go for something different than the usual hyper real colour portrait. For example check out the stuff that Bez from triplesix does - amazing.
What I dont like however, is skin rips , has to be the shittiest of all tattooes, esp when combined with realism.