Camshafts are very confusing if one doesn't know how subtle changes in the grind will affect the engine's performance. The Pontiac Street Performance site has some good articles on camshafts, but unless the claims are backed up by actual test comparisons, they may just be someone's opinion. And as Oldskool says, opinion vary a lot.
The 041 camshaft will have a higher operating range than that of the 068 or the 067,744 and 066. Pontiac usually put cams with a lower duration in automatic cars than manual equipped cars. One would have to know all your engine specs to give a guess as to the actual rpm range. A bigger cam may give you more horsepower but that usually cost low end torque, and the higher horsepower will be at a higher rpm.

What you should really look at is what you intend to use the car for. You stated you want to take the car out to the house on the lake, well you don't want to drive down the highway at a steady 4500 rpm. You may get 375 horsepower at 5,500 rpm but how often are you going to be driving your engine at that rpm. Are you building a race car or a street car? I built mine with the Idea of driving up a long hill on the highway with enough torque to leave the tranny in overdrive and not have the engine revving over 2,500 rpm. I have 535 HP available to me but that is at 5,000 rpm, I don't drive it at that rpm very often. One has to be honest with him/herself when deciding what the purpose of the build is, and go from there.

Quite often people get caught up in numbers, it doesn't mean anything to you if you have x hp or y hp, it means a lot to have a car that performs well the way you drive. Good idle, good torque for starting from a red light, smooth running without overheating, enough vacuum to run accessories, enough power to pass someone on the highway. But if you want to build a monster power engine, go for it. Just remember it's driving manners may be poor.