I like 22" for general use. My urrent studio kit is a D Drum with a 20 inch deep kick....I prefer more depth to greater width myself, but but it a;; depends on the music. 24' and 25" can sound great as long as the part doesn't get fast or busy. The head doesn't return to neutral fast enough on a big drum, like a 26. I did have a nice 24 custom kik for a bit, but this deep 22" is really making the clients happy.
What I like to point out is that a sucky band in a great studio will produce a pristine recording of crap.