I’ve actually found this useful more often than not. To do it well you have to point to genuine differences and not just say “Product X sucks and we’re awesome!”

The ones that seem least useful are the aggregator sites making comparisons written by robots. But I’ve gotten genuine insight from competitor profiles.