There is no objective "sweetest" breed, as temperament varies by individual. However, breeds often described as gentle and affectionate include Golden Retrievers, Labrador Retrievers, Beagles, Cavalier King Charles Spaniels, Bichon Frises, Poodles, and Pugs.
Training, socialization, and meeting the individual dog are more important than breed alone when choosing a companion.