How can I generate overflow condition from a 74'283 or 74'181 adder without an output pin of the carry-in of the MSB?
You don't need to see the carry in, you just need to see the result. If the carry out and the MSB of the result (i.e., its sign) are the same, there was no overflow. If they are different, there was an overflow.