I don't get all the hate against Caprica. It's true that the acting and SGI was quite poor at times. It's worst crime was that at times in turned into a quasi rebellious teen drama. There are some fantastic moments in it though. It goes a long way to explaining the rise of the cyclons in society and how they were fundamentally flawed from the start. I'm surprised that a BSG fan does not enjoy the series for that alone. As a stand alone program it is a pile of poop though.
The problem is that it was aimed at a niche audience of a niche show that was part of a niche genre. It's hardly surprising it didn't get any viewers. BSG had drama AND action and it did well because of it, it wasn't just nerd shooty shooty and flux capacitors and it wasn't just hippies talking about love and feelings and stuff. It combined both and people expected more of the same with the spinoff show and it didn't deliver as expected.
If they made a Rambo with 90% less action and filled it with teen angst, betrayal, robots and religious nutjobs it too would get hate, regardless of what it could have been or what some people got from it.