The House of Games star suffers health scare after kidney stone left him waking up in agony and needing surgery to have it removed