What are the pros and cons of PN upgrading to MySQL 5 and ...

[#1]

.. how difficult/involved is it ?

[#2]

I suggest taking a look at this thread and perhaps adding your thoughts to that.
The upgrade doesn't appear to be something for which there is great demand.
David