I'm an ex-academic (PhD in sociology) turned project manager, almost 10 years experience now - as previous poster said, PRINCE2 is a very rigidly structured framework that bears little resemblance to the reality of running projects... at the same time, most organisations recruiting project managers will ask for when recruiting, so it is pretty much essential if you want a project management job. But don;t expect that the course will teach you much about project management,
I've passed the exams but have never used it on a project. All the PM contracts I've had have used in-house systems or things like Remedy (going back a bit there!). I've only got my Foundation now as I haven't bothered to go back and re-sit but I do find it useful sometimes, when I have to point out to some arse that I do actually know my stuff, even if I don't have forensic knowledge of their tiny little component.
Agree with all pp... P2 is a box tick if you're recruiting a PM but tbh you'd be better off getting some real world experience in whatever way you're able then doing a qualification. I wouldn't employ a PM just because they had P2. Also agree re Agile being a more in demand qualification right now, though depends what business you would be looking to move into.
Not hugely helpful reading the above, sorry, it's difficult to advise more without a bit more info re background, aims etc.