In an intoxicating exhibition at the Aldrich Contemporary Art Museum, portraits of steel and glass are filled with psychological drama