Morita theorems for categories of comodules