Not too long ago I helped a pair of pickup artists/dating coaches do a marketing plan and organizational model. Had to do a ton of research into the industry and the theories and what have you. I have really, really, really mixed feelings on that world, and I'd probably avoid the forums if I were you.
As for magic tricks specifically: Yes, a magic trick can build fascination and show that you are interesting. But imagine you had some sort of magical relic from thousands of years ago. You show it to a girl, she's really interested. Then you use it to hit on her. Most girls will think it's terrible and cheesy and out of line with the moment she thought you were having.
Really the problem with trying to impress someone with a trick, you are trying to impress someone with a trick. At the end of the day if you feel needy and want to impress people, you will either drive people away or attract the wrong kind of person. If anything you would probably want to show a good trick and downplay the crap out of it, then switch into a palm reading or some psychology game (like a fun game, not game as a word for pickup skills). I know a few of these and they're great for life, not just for women. But really it should just be about being playful and having fun, not about impressing anyone.
Some people have mentioned going the pickup route. If you do decide to do the pickup thing, forget lines, tricks, and systems and try something a bit more holistic like RSD. I have my own issues with that method, but I think it's among the best out there and it's going to be easier to transition from pickup to regular relationships. Otherwise, I'll say this: Pickup will get you results, but maybe not what you were looking for at the start. Most guys I met and interviewed were good people who were worth a woman's time, they just didn't know it or were too afraid to put themselves out there. I hope they ended up getting around that without forking over tons of money or believing that they have to trick people into liking them.