Don't underestimate your hands. Muscles will learn how to fret on a regular scale bass. I have smaller hands, can do a full four fret stretch in 1st position, which would not be considered proper technique, but whatever. I don't think you need to base your decision on what bass to get just because you have smaller hands.
What you should look for is what sounds good to your ear, compare what some of your favorites might be using and think about whether or not that might fulfill your goals for sound.I'm guessing that Sleep is probably high on your list based on your user name and music interests. Al used Rics, and Lemmy is a Ric man as well and he used to play in Hawkwind they can be pretty pricey and used prices aren't much better.
Now for heavy psych rock you can get just about any bass to work in my opinion and the reason I say that is because the signal usually gets some pretty heavy effects gong, a little chorus here, some fuzz there, and oh should start playing with the wah pedal now...
So you may need to consider that in your decision as well, and that is a whole other can of worms.
All that aside though, what sounds good, feels good, and really gets your eye is what matters in the end. Those things will make you want to play more. So get out there and mess around at GC and find some mom and pop shops around or local music chain that has some brands other than Fender, Ibanez, Schecter, and Ernie Ball (GC staples). /ramble