1) First of all. Forget the "bad reviews"... forget the reviews in general. If you like the way your lens works, enjoy taking photos. You need to test your lens and know the specific flaws you detect. Ok then you can read a review to understand what you already see.
2) In my humble opinion. Manual focus in a digital camera without a focusing screen is a pain. Any improvement you have in sharpness you can have, you will loose it focusing the wrong distances. Specially in wide apertures. Not even with live view.
3) Depending on how old are we talking about. I have some old interesting prime lenses. Old enough to have some chromathic aberrations on all of them, things that I did not noticed when using film back in the days.
4) You will use a manual lens probably in a studio with controlled situations, a tripod, a still life that is not moving. If not, use an auto focus lens. There is no hurry. But if the lens is really cheap, go and buy it and have fun with it.
Here is a test. Nikon 3300, Both at 5.6, ISO 800, 1/60, white balanced with the kit lens. (Excuse all the dust, but gives some references to see how sharp it is)
Kit lens on the left. A 1970's f1.4 prime to the right. (I probably did not focus the exact same spot on both cases)
I see a little more sharp the image on the right, (the old prime). But not that significant. A little green tint is present.
But when using the old lens at 1.4 a lot of distortion apears.
This obviously is a case by case topic.