I have read that we define the "2-norm" of a matrix as
$$\max_i \,{|\sigma_i|},$$
which I have also heard called the "operator norm" (here $\sigma_i$ are the singular values).
Also we have the norms
$$\|A\| = \left( \sum_{i,j}|a_{ij}|^q \right)^{1/q}$$
for every $q\geq 1$. Do we refer to these as $\|A\|_q$? (For $q=2$, I have heard this referred to as the "Frobenius norm".) If we do refer to them as $\|A\|_q$, then how can we reconcile the two meanings of the term "two-norm"?
Subquestion: How can we bound the values of $\|A\|$ for $q=1$ and $q=2$ in terms of each other?
The operator norm is a matrix/operator norm associated with a vector norm. It is defined as
$||A||_{\text{OP}} = \text{sup}_{x \neq 0} \frac{|A x|_n}{|x|}$
and different for each vector norm. In case of the Euclidian norm $|x|_2$ the operator norm is equivalent to the 2-matrix norm (the maximum singular value, as you already stated). So every vector norm has an associated operator norm, for which sometimes simplified expressions as exist.
The Frobenius norm (i.e. the sum of singular values) is a matrix norm (it fulfills the norm axioms), but not an operator norm, since no vector norm exists so that the above definition for the operator norm matches the Frobenius norm.
As far as I know the "q-matrix norms" as you define them (I have never seen these before, and I am also not sure if these fulfill the norm axioms) do not match the q-vector norms as corresponding operator norm in the general case (this is more complicated, I think).