I think it depends how fussy you are, I know some people use them and are very happy with them, personally I know I wouldn't be satisfied and would doubtless end up peeling it back off again(I would always look at it as a sticker and would bug me).
I know decalgirl was always one of the popular suppliers of console skins, haven't seen it discussed much recently so don't know if there are any better brands/companies to use.
If you're brave and don't mind voiding any warrenty you may have then you could always do it in style and change the console case with one of the many case mods available, see
this thread.