I recently watched HBO’s The Time Travelers Wife full well knowing there was only one season. I think I mostly regret it. I loved the show, and knowing there won’t be any more to watch has bummed me out for the past week. I can’t remember feeling this way about any other show - it sucks.
Getting cancelled isn’t a sign of a bad show so if it looks decent I will watch anything. Also if you enjoyed The Time Travelers Wife then you shouldn’t have regrets.
I don’t think it’s so much a sign it was bad, moreso that it could be left on a cliffhanger or unresolved plot points.