I think that the database is certainly in the 90% range, and when a device is included it's generally got a pretty complete set of commands. The only problem I have is that the layout isn't always as intuitive as I'd like, which is why I tend to start from scratch in many cases.
Assid seems to be having the most trouble with incomplete user files (collected typically from
Remote Central ). I did find that a device file for his display (the
one from Ryan Doyle , if this link will work) did have discrete power on and off commands assigned to the on and off buttons. In the case of the SA 3100HD, it uses the code 043 (one of the two codes for Time Warner boxes), and both the on and off buttons show the same power command assigned to them. If you or assid had a macro or some sort assigned to the power on and off buttons, that could have superceded the IR code on those buttons.
Here's a screen shot that may help explain what that last paragraph said. The device shown is the .mxd file I mentioned for assid's TV. The "ON" and "OFF" buttons both have IR commands assigned to them, and the details about the "ON" command can be seen both in the tool tip and the "Edit and Label Buttons" window to the right.
Cable box code 043 (the Time Warner code that is used for vince's 3100HD) is similar, but both the "ON" and "OFF" buttons have the button name "POWER" (a power on/off toggle rather than discrete on and off commands).