Depends on cubic inches too. The smaller the engine, the more radical the cam will sound. For example, the old Duntov cam in a 350 will sound pretty mild. In a 283, it will sound pretty radical.

Get a P.A.W. catalog (Performance Parts Warehouse). They carry everything, including cams from different manufacturers. They will list the applications for each cam profile and what you will need to reap the benefits. (ie: cubics, compression, convertor, gears, etc...)