While the AI opportunity is massive, investors are being cautioned to maintain discipline and avoid letting hype cloud their financial judgment.