After more testing, I can't really overclock to more than 245MHz if I want good sound:-
245MHz and below: Sound is perfect
246MHz to 255MHz: PicoDrive runs, but sound and FMV are affected. The closer to 255MHz, the worse it gets.
256MHz and above: PicoDrive normally crashes with error message when trying to load a game.