BUG: fix concat of Sparse with non-sparse dtypes
Closes #34336

This adds tests with the behaviour as it was on 0.25.3 / 1.0.3, and some changes to get back to that behaviour.  
(but whether this behaviour is fully "sane", I am not sure ..)