In a way all experiments are quantum. The tube-ball-finger experiment you describe is "macroscopic", involving objects of dimensions we are acquainted to from our everyday lives. Looked at more profoundly, it involves a vast number of degrees of freedom. The tube, ball and finger consist of a large number of atoms, each in principle interacting with an even huger number of degrees of freedom in the environment (air molecules, photons). This environment also is a quantum system. Two quantum systems interacting with each other will form an entangled state (which is a pure quantum state). If you consider only the tube-ball-finger (TBF) system, you are disregarding the degrees of freedom of the environment. The results of experiments on TBF can statistically be described by a reduced density matrix, obtained by tracing out the degrees of freedom of the environment. This reduced density matrix will be (almost) diagonal, with off-diagonal elements, corresponding to quantum interference effects (almost) gone. As quantum interference effects, related to superpositions of states, are a specifically "quantum" phenomenon, by the coupling to the environment this "quantumness" is suppressed. This is known as local decoherence. Decoherence achieves this diagonalisation of the reduced density matrix without any additional processes, simply by treating the system (TBF) coupled to the environment as a full quantum system. You could also couple the system to a measurement apparatus and this then to an environment. The mechanism remains the same. Note: The full quantum system, i.e. TBF (+apparatus) + environment remains in a pure quantum state.
As for a collapse of the wave function (or changing the system by observing it):
It only makes sense to talk of something like that if you perform a measurement on the system and then another one (and then another one ...). If you do N measurements, you can say you have obtained N values. But that statement is incomplete. What you really have obtained is one ordered sequence of N values. One measurement result, consisting of the results of N "sub-measurements". This sequence has to be logically consistent. This may look like a collapse - but I find the word doesn't capture what is happening.
Example: Double Slit Experiment. After the double slit, not just a screen (which swallows "particles"), but a sequence of detectors following each of the slits. If the first detector after slit 1 indicates the presence of a particle, so necessarily will the 2nd, 3rd, and so on. You won't have a sequence of results where, e.g., the first and second detectors after slit 1 indicate a particle and then the 3rd detector after slit 2 (unless you have set up a mechanism to couple the paths after the slits - or you have more than one particle in the system and detectors are not perfect).