I have not seen the movie Limitless, but was aware of the premise. I wasn't really interested in the pilot for the new TV series, but I happened to catch it by luck. I was glad I did.
The show follows a man who hasn't done much with his life. In a temp job, he runs into an old band mate, who sees in him potential and gives him a super pill that unlocks the deepest recesses of his brain (makes him really, really smart). The plot follows him as he is chased by the FBI who want him for murder, while he tries to clear his name.
There's really nothing new to the show that we haven't seen in other shows in the crime procedural genre, but it works. The acting is good. The pacing is good. The possibilities are there for some twists. It sets up a good overarching mystery. Overall, if you like TV dramas like Mentalist and Chuck then you'll like this show.
As an aside, I thought it was WAY better than Minority Report, and that was one I really looked forward to when it was announced. Of the pilots I've seen, Lucifer was better. Player was okay for some silly action fun. Quantico has a better mystery. But Limitless is in the top three.