There isn't anything noteworthy about it beyond how stupid people are. People hate Matt Hardy so they just picked something, Hogan-Sting being on there is a flat out joke and Morgan-Crimson was far from worst. IWC types dislike gimmicky non-wrestler matches so that is all they will admit to WWE doing wrong. Big difference between worst match and what "I don't like" but people aren't capable of figuring that out.
I agree that you should not judge a non-wrestlers match by the same standards but I do not think that is why people didn't enjoy Cole-Lawler. In those type of matches you have to judge the story and it has to deliver something when it is given so much prominent airtime. They have a responsibility to deliver something passable if they are going to be given all that time in build and on the show itself. If they can't, don't put all that time into building up peoples' expectations. For some inexplicable reason they decided to try and put on an actual match and completely botched the story.
Coco is correct to an extent that expectations do play into things, however, I think there are a few key differences here. First, the main reason expectations do matter is because they come from the build which impacts the match. There was not much of a build to Hardy-Sting. Second, people are claiming that a divergence from expectations is what matters. Why is it that we are saying that if I expect something to be good and it is then that makes it a best match candidate but if I expect something to be good and it isn't that makes it so much worse than something I expected to not be good? I do think it is fair to judge a match on both build and in-ring action but the fact is people are judging the Hardy-Sting match on neither. A squash match isn't the worst match of the year even if you expected something different. There was no in-ring action to judge in the first place which has been the common sense way to judge such matches for a long time up until this happened in TNA.
Royal Rumble gave me very little for how much it was built up. That Hornswoggle stuff was terrible although it was fitting because the match pretty much turned into a joke. I think it started decent and then went to hell and ended terribly. Aside from Morrison spot and Diesel pop I remember nothing of interest about it. Easily the most disappointing match I remember seeing in WWE this year although I can't remember watching many so take it FWIW. I wasn't expecting much from Cena-Miz but for a main event that thing really did fail to deliver. If expectations matter then Wrestlemania was easily the most disappointing show of the year. When Snooki outperforms most of the roster that really says something.