Both ways will be unsuccessful if you act that way in an attempt to seduce a woman. There are also more options than this, on top of that you can both be aloof and funny on the same date.
Nobody has a one sided personality, if you focus on being just one particular way, all you will accomplish is to be weird. Normal people have multifaceted personalities, interesting people have that.
It's common to think you'll come of as too eager if you try to be funny and too cold if you act aloof. That is true, which is why neither is a good option for the entire date. You can crack a few jokes, but by not trying to be funny all the time you seem balanced. You can be aloof for a moment, but by snapping back into the interaction you seem more balanced.
Take a look at women when they take this effect to the extreme on some poor guy who doesn't know better. They're hot and cold, one moment showering you with affection and the next being cold and distant. It manipulates the motivation of a guy from both ends, he desires more affection and less of that silent treatment.
Now I'm not telling you to emulate such extreme contrasts, it's not healthy. However, the principle also works for more moderate behaviors without being destructive.
Don't be one sided, it makes you boring, very easy to read and weird. Just being yourself, flowing with the moment and being unafraid to expose several facets of your personality as it naturally emerges in an interaction is the easiest way. Don't try to emulate this by thinking "now I'll act like A for a bit, then B for a bit, then C for a bit", you can't do it.
Just simply stop thinking about the "right" way to act on a date or what way you think impresses her the most. You do you and you judge HER on whether she's really interesting enough for you or not.