In a domestic setting:
Cat7 - totally over the top and uneccasery.
Cat6/cat6a - overkill, but if it makes you happy so be it.
Cat5e - perfectly adequate and easy to run/work with. Not going to have any problems running a few cameras.
As someone who's run a fair bit of cat5e, cat6a, even run...