Samick , When I had the music store they were my # 1 cheapo guitars and basses. Back in the 90's they were still made in Korea. But they blew away all other low end brands. The finishes and necks were first class. I sold ton of them and everyone was happy. Plain ( Black/Red or White) finishes sold for $199 back then.
Of course you must realize that no matter which brand, including low end Fenders, the Pick ups will be sub standard. But that is super easy to upgrade if it is a standard Fender type PU. Weird PU are sometimes hard to find upgrades for. But thankfully most el cheapo brands use Fender type PU's. The common configuration is the P/ Jazz combo. P Bass PU are split so there is 2 offset, Jazz PU are narrow and one piece. My Hondo has a standard P bass so I bought a Dmarzio for $70 that made a huge difference.
Bass guitars puts a lot of tension on a neck, that is why I said to be careful about twisted or warped necks. Pick it up and look from the bridge along the strings towards the nut. It should be nice and level with no side to side variation. And look for frets that are all level and not looking like ties on an abandoned railway line.
There should be no string buzzes and it should be easy to play. You don't want too low an action on a bass but it should not buzz if played a little aggressively.
I don't recommend buying a short scale bass , sometimes called 3/4, unless you want a dull thud kinda sound. Short scale basses do not have the same tension on the strings so have very little twang. They are the opposite of the sound of a Jazz bass or Ricky. I used to own a Gibson EB0 which was short scale. I used it for Bluegrass.
Another thing to think about- The biggest problem with shopping used is people who play and are knowledgeable about this stuff, only sell instruments they don't like. So look for used among people who don't have a clue and bought it but never learned to play. Pawn shops always charge double the going price.