Yes, it feels impressive to me. No, not without major work. It does have a manual transmission, and they are fragile. I'm on #3, and I'm gonna have to pull it again because it's popping out of fifth when the load changes directions (accelerating and let off mainly) currently. I'm on the third transmission and fourth clutch. I completely rebuilt the engine (down to split cases) back in fall of 2021 at 363k. Everything looked beautiful inside, but the head gasket had failed. Failure mode was external oil leaks initially (just kept adding oil and drove it for thousands of miles because I had too many other projects at the time).
Finally, it started pressurizing the cooling system. I drive about 30 miles one way to work and then back every day. For a few months, I just kept adding coolant, and then finally decided to rebuild it when I was adding coolant twice a day. There was one bad deal with driving it with the bad head gasket so long. One of the heads was "welded" to the block via corrosion around the head bolts. I ended up getting a little western pulling it off, cracking the block in the process. I ended up having my rural neighbor, who builds hopped-up V8s in his home shop full-time, weld-repair and deck the block, as well as do a valve job on the heads. I replaced all the bearings in the engine. I replaced wrist pins and bearings, but I couldn't find new OEM or aftermarket pistons anywhere, so I cleaned them up and they are still in there! I have 27k on it since the rebuild now.
The engine seems very well-designed, and durable, sans the head gasket issue. That's a tough one to solve because it's due to the vertical head gaskets. Oil, slightly acidic from combustion by-products, sits in the head and slowly eats away at the gaskets and the block and head surfaces. The pooling of the oil in that area drives it in between. Subaru has tried at least three different head gaskets over the years. One of them (I think the 2nd one they tried) was horrible. The other two are about the same. They work, but only for so long.
The manual transmission in mine has definitely been fragile. Clutches aren't weak. The reason I've had four of them is I put new clutches in every time I change transmissions, even though they didn't need to be replaced, with one exception. I had one aftermarket clutch fail, but it may have been my fault. Assembly didn't go well...
Other than the manual transmission problems, and the head gasket problem, I've had no major issues. Everything else is pretty bomber on the thing.