For normal use I would suggest the 44 special CCI-Speer Blazer's with the 200 GDHP. Or if you want a bit more load it to +P levels in 44 special brass (1050 fps or so).
For special situations. Such as high threat times or if carried as back up to a 9mm, 40, or 45 I would suggest the 44 mag 210 Win Silvertip or the 44 mag 180 Fed JHP.
I think Garrett's 255 WFN or Buffalo Bores similar load are excellent ideas for hiking in the lower 48. Plenty of penetration and slap for defense against people, dogs, or bears. With my 4" 629 I normally keep it loaded with Speer's 200 Blazers but usually keep one speedloader filled with Federal's 300 grain Castcore, a LBT LFN in disguise, just in case. When I get around to ordering some of the 255 WFN's I will probably start using those instead of the Castcores.
As to the 44 mag being overkill that is a matter of opinion. Some people actually carry & use 44 mags in real life. Not a lot of people I'll admit.