I don(t know, I think it depends on your style, if you have that scalping mindset, and don't have any problems getting back in the same trade after getting stopped out, tight stops can work.
PS: I guess it depends on the product you trade too. I would use tighter stops in nq then ES, because nq...