So it seems that consciousness and attention can have effects in the physical world
Of course it can, what do you think is controlling my arms as I scratch my arse? It has other names, spirit, soul, mind, etc. There's a reason scientists and philosophers alike call consciousness "The hard problem", it all boils down to the fact that you can never fully understand yourself. You are not separate from the rest of the universe, you and the universe are one (or as Sagan put it) "We are the part of the universe that observes itself", and by extension that implies we can never fully understand the universe. I don't know about anyone else but like Feynman "I'm ok with that, I'm not afraid of not knowing, I find it more interesting".
Having said that the world is full of scammers who use very clever magic tricks to separate the gullible from their wallets. The "clever" part is that they know enough about the human mind to be able to distract it from what's really happening. Of course there are others who truly believe they have special powers but they always turn out to be mistaken when put to the test.
To summarise: Wake me up when James Randi pays out on his million dollar challenge.