Cohomological dimension, cofiniteness and Abelian categories of cofinite modules