Betsy, IF you are only concerned about sound, Comp Cams offers something they call their Thumper series. They sound great, BUT may not be the best choice for your actual DRIVING agenda.
As you get into this stuff, while 'sound' is nice to listen to, there are other factors to consider IF you also are interested in drive-ability, satisfactory performance for your driving type, and driving pleasure. Things like idle quality and low speed throttle response in stop-and-go driving are examples. The camshaft is a primary determiner in engine performance although its selection is based on numerous other vehicle and engine variables.
Selecting THE BEST cam for your application is NOT a one-fits-all proposition.
1) How will you be using your car? (street [stop-n-go], highway travel [elevated operating speed] )
2) What transmission are you coupling it to? (manual 3 speed, 3 speed w/ overdrive, automatic, or other)
3) What rear end ratio will you be using? (IF you've got it, the glove box owner's manual should identify this for the engine your car was assembled with)
4) Engine variables
a. what cylinder heads are you using? (these determine the static compression ratio and the intake valve size; see http://ford-y-block.com/cylinderheadchart.htm
b. what rockerarms are you using? (Ford used two different ratios; the ratio affects valve opening rate and the actual valve lift; see http://ford-y-block.com/rockerarm.htm
c. engine displacement (VERIFY that your engine is a 312; see http://ford-y-block.com/identify312.htm
d. what intake manifold and carb will you be using? (two barrel, four barrel, multiple carbs? the casting numbers of your FoMoCo intake will tell us if it is early small porting ['56 312] or later big porting ['57-'60 312] )
General comments: 1) The same camshaft used in a 272, 292, or 312 engine yields substantially different engine manners in each! 2) The same camshaft used with different cylinder heads and different rockerarms will perform differently. 3) Also, I did not list vehicle weight as a variable because you told us that you've got a '54 Ford. Vehicle weight is a factor in cam selection just as transmission type and rear end ratios are.
I don't mean to make this complicated, but you definitely want to get your cam selection right. One of the nuances of the Ford y-block engine series is that the cam IS NOT easily changed after engine assembly as it is on other series of Ford or other manufactures' engines.
Hope this helps.
a.k.a. Charlie Brown
near Syracuse, New York