Will drain camera see whether P-trap is filled with water?
Yes, they should get you the answer you seek. It should be plainly apparent whether there's water standing or not.

You can buy cameras that do what you need for much less. Note that there is variety in the type and rigidity of the cables, so read carefully.