Scott Weiland was 'one of the most fascinating frontmen'