My most comfortable ever would have to be the original Playstation controller. Not my favorite controller though.
Gamecube controller is still my favorite. The way you have to grip the controller tight creates too much heat for it to disperse properly, so I always used to end up with sweaty hands.