It probably doesn't work very well on me. Anything that looks sensationalist, even the use of an exclamation mark, doesn't arouse my curiosity, I just think "that's probably rubbish" and move on. Sometimes I strongly suspect a thing is clickbait but I'll look anyway just to see if I'm right and to give me evidence so that I can expose the authors, e.g. tabloid newspaper editors, as the charlatans they are, to anybody likely to listen to my rants. If it's a Facebook off-site link, I'll normally copy and paste the title into DuckDuckGo, which usually shows the link as the first hit, along with a bit of text from the page, and that avoids the Facebook tracking and often avoids the need to bother visiting the page itself if the DDG text shows it'll be disappointing.
I've been tricked by it on WP though, if misleading thread titles count. I'll see a title that looks like it'll lead to a general discussion of a subject I'm interested in, so I'll click it in the hope of being invited to air my views, but it'll turn out to be about the OP and some matter that has little to do with the title. Not saying it's always deliberate. And there's nothing to stop me airing my views on the topic given in the title anyway, though if it's somebody looking for advice about a serious problem then I'll probably not do that.