The mod Archery Evolved : Reborn - Classic does exactly what the OP wants. Without boosting damages in an unrealistic and ludicrous way.
I use it and, imo, it does the job of making archery more useful in CE. But it isn’t ultimate. You still need to use a melee weapon if your target is fast enough to come close before you kill it. But I’m not very good at kitting with CE.