It definitely depends on what kind of diaper I'm wearing. If I'm wearing a cloth diaper, I prefer the dry times. If I'm in a disposable, I prefer to be soggy.
I prefer to be in wet diapers but it's easier for me to get aroused, if that's what you mean, in dry diapers - partly because it's hard to go straight from being in a wet diaper to having sex.