Saw a very tall kid with very little athleticism go to a D2 as a pitcher. 6'8" and heavy, he was a project as a pitcher since he never threw hard in high school. Low 80's at best. Redshirted a year, didn't get off the bench the next, and quit baseball. Never had a winning record in high school or legion. But, he was big.
As far as college camps and showcase camps with a pro style workout... If your kid has good size, very good speed, and athleticism, and hits and fields well enough, then do it. If your kid produces during games, but doesn't have great size, great speed, and athleticism, then he's not going to be discovered at a camp.
If your kid is of average size or small, and has average or below average speed, then don't waste your money. The exceptions would be a kid who throws extremely hard for his age, or hits several out during bp. Those two things would get noticed.