I think sparkly nail polish looks tacky when it's not solid like this: link
But I think the link you showed looks good. A trick is to put an opaque color underneath and then put the glittery one, it'll look more polished. For example, I loooove this one: link but it looks so much better with a silver ish color underneath so you can't see any of the actual nail bed. Also, don't let it get chipped because then it'll look nasty lol.