‘Sheikh Hamad will be fondly remembered across the Gulf’