My Caprice has a 700R4 with 3.08 gears from the factory. I want to go to 3.73's but is the acceleration difference over the 3.08's going to be worth it?

You will definitely notice a difference going to a rear with 3.73's in it.

You will not be disappointed. Just remember you will need to recalibrate your speedometer.