I assume by "ill posed" you mean poorly conditioned, i.e. potential numeric stability problems associated with inversion.
Like I said in your thread here:
https://www.physicsforums.com/threads/how-can-i-analyse-and-classify-a-matrix.931056/
it's the ratio of the largest singular value to smallest singular value that matters. I really struggle to imagine why you'd take that information and then ask a question about about adding up all the squared singular values, and asking what that sum (or the square root of that sum) tells us about condition number.
- - - -
Not really need to go through an entire book for this. It's actually as comprehensive as you wrote here, which I was not aware of. However, the strange thing is that if the ratio between the smallest and largest values of the matrix is in the magnitude of 10^40, it defines an ill conditioned matrix, and the Max norm is very high, about 78. However, the Frobenius norm is "only" 1.5 , so I thought it was strange these two norm would deviate so much.