A cartridge "sounding dull" is more likely to be an issue that is resolvable via custom loading (or Digital EQ) than via needle change.
A needle change will alter the frequency response, but given we don't know the effective tip mass/cantilever resonance, the result is completely random
Same deal with swapping cartridges - every cartridge/needle combination, will need its own independent loading for optimal results..
If you keep the load static at 47k and whatever capacitive loading you have, you will effectively be randomly adjusting your frequency response by swapping cartridge and/or needle.
If you have the time and patience.... you can experiment with cartridge/needle combos until you find one that suits you, or alternatively pick one that has decent underlying performance parameters (good needle profile, alignment, low mass cantilever, output level of cartridge is a good match for your phono stage, etc...) - and then adjust the R and C to get better results.
Keep in mind, that unless your phono stage is designed for varying the R&C, R can only be lowered (by putting additional R in parallel with the existing R, using double adapters and R plugs), and C can only be raised (longer cables can easily do that!)
I have had cartridges running with R=27k to R=80k, and C values ranging from 60pf to 700pf