Ethan-
Noting your post count, your avatar with a 5 speed knob, and your '01 Forester ownership, I'd answer your post this way:
1) everything's relative...your Forester is non-aspirated, which is to say, without turbo. In the context of all FOresters, the 01 and other non-aspirated Foresters might be considered sluggish (by those of our elitist contingent of this forum).
2) To get the most acceleration out of the n/a Foresters, 4000 to 5000 rpm shift points might be about right...the horsepower/torque curves would suggest that anywhere between 3500 and 5500 rpms would allow for more spirited driving, as needed by circumtance.
3) To be using these shift points, you must consider your surroundings and safe operation at the speeds these rpms generate. I can think of a number of curvy roads with great preview of coming curves, where second and third gear hard running would be lots of fun. Notice that I said contingent on preview of roads, so that there are no suprises!
4) I drive an 04 FXT, arguably the fastest stock year and model Forester yet made by SOA. With a 4EAT, the shift points can be forced as low as 2500 rpms and as high as redline. With the turbo (small as it is, and nothing like those selected by modders on this forum), running full throttle from 3500 rpms and up quickly becomes a handful in tight corners, and I'll usually lock in first or second in this context (track or favorite twisties), selecting third for larger radius curves, where access to second is still available on demand (shifting down manually at speeds less than 55 mph).
I think the thing to remember is that it is only superb engineering that permits SUbarus and Porsches to get the outputs and engine speeds they get from a boxer engine design. Low end torque permits 'shortshifting' with still good acceleration, and much longer engine life.
Higher engine speeds and outputs are much easier (read cheaper) to obtain from inline engine designs (one of my favorites, the Honda S2000, which generates more horsepower than the larger turbocharged Subaru 2.5 liter engine, from an engine that isn't supercharged and is only 80% of the engine size. But at 10,000 rpm. The S2000 is a dog if upshifted in the 3500 to 5500 rpm range...but hang on when running 8500 and up~!~!
-Quick