The last bass that would have been a great candidate was my Squier 72 Tele Bass. It just had a neck mudbucker, I toyed with the idea of routing it for a 51 SCPB pickup or SF. In the end, I didn't like the bass enough to keep it, so it was sold. Maybe someday, when the right bass pops up... I have one SF left in the parts drawer. However, a neck SF is 28" from the nut on a Foundation, a '51 SCPB is 27 5/16". Not terribly different, as far as harmonic content is concerned.
I extensively compared RicRiot to my round wound Foundy. Same strings, same basic set up, same amp. It's not super duper different than the neck pickup on a Foundation. It's at 25 3/8" from the nut. When you compare it directly to the neck pickup of a Foundation, there is a noticeable extra depth and fundamental to it-kind of like boosting 60hz a couple dB and cutting 250hz a db or three. Not radical considering that the pickup moved 2 5/8" towards the neck. It's much more noticeable playing solo vs in the mix. With the band, the RicRiot just gives more variety with it's 3 pickup settings all being good for supporting general rock/pop music. With a Foundy, I only use soloed neck or blend of both. Soloed bridge is too thin without a bass boost.
I think that physics dictates there isn't as relatively a drastic change in the tonality as you move pickups towards the neck. When moving towards the bridge, the harmonic content shifts much faster as you read a shorter and shorter part of the string. Think of it visually like the frets: they get way closer as you move towards the bridge and the pitch changes more drastically with the same distance change. The harmonics read by the pickup react much the same.
There is a much more noticeable difference in the tonality in the bridge pickup of RicRiot vs a Foundation. The Foundy is at 32", the RicRiot at 29 5/8". That 2 3/8" location change towards the neck makes the tone go from thinner & focused to punchy, yet tight. I wouldn't want to gig a soloed Foundy bridge pickup, but the Patriot can hang and keep the low end supported. Comparing the Patriot to the Foundy neck pickup is just a slight addition of some depth.