Well, not necessary. What I do is that I balance the output, meaning that if I have a high output pickup, I might make a normal output neck pickup, or one that is just a tad over wound. If I however make a more standard output bridge pickup, the neck pickup often ends up a bit under wound.
I totally agree with Carl, High output pickups became "the thing" in the early 70-s starting with the DiMarzio Distortion and similar pickups. Back in those days the amps didn't have that much gain and you needed a high output pickup to drive the input stage of the amp to get a lot of distortion. Today the amps have much more gain available and the need for a high output pickup just to get the distortion is obsolete. OTOH, a overwound pickup have a distinkt sound that many people like. Me, I prefer my pickups in the range of slightly under wound to just a tad over wound. Often SCs benefit for a bit more "meat" but HBs kan really shine and let so much more of the overtones and sweetness of the string come through if they are a bit on the "cooler" side. But really, that can aslo be achieved, to some extent at least, with different "tricks" on a high output pickup.
For the request of "lots of mids and lows" that is really a bit of contra-dictionary to the wish of good articulation. If you overwound a pickup the treble always take a bit of a hit. To counter that you can play with factors like unbalanced coils (wind one up to 10% hotter) or try to reduce any metal, magnetic or un-magnetic in the proximity of the pickups (i.e. covers, base plates etc). Check out the fibre base plates Mojo sells. And go easy on the unbalancing of the coils for the bridge pickup. That is often more beneficial on the neck pickups.
Carl, if you think ceramic magnets sound ice-picky, let me share a trade secret: "High power" AlNiCo 8 magnets. The output and "attitude" of ceramic magnets, but with a bit "sweeter" high end.