"Bob's effusive and repeated expression of love is the greatest gift that he left people," said John Mayer