I would say that while Manaphy is one of the worst Ubers it can still be a very effective pokemon IF you build your team around him.
He simply isn't versatile enough to just slap on any team and expect success, you need to have eternal rain making Kyogre a must and then you must have pokes that...