Well i own three ESP basses and feel the need to defend them here (Inclding the F-104, the F-404 and a B-255) now granted i like pointy basses (I also own three B.C. Rich basses a Warlock, and Mockinbird, and a Virgo) not to mention an Ibanez Iceman. IMHO there is no company out there that compares with ESP based on what you get for the price. The F104 you asked about is just one step above their entry level bass in the "F" series. It is made of Agathis which some people have issues with (And i'm not sure why because this wood is commonly used in the manufacture of mid-ranged guitars and basses, due to its good resonating properties), but it is 35" scale, has a maple and rosewood neck with 24 frets, and has a two band active EQ. For its current strret price of $299.00 new it cannot be touched for build quality and features. The body style is a little extreme, but very comfortable to play. The EMG designed ESP stock pickups are not for everybody, but i really dig the sound as well as the EMG 40DC's in the higher priced models. People who make blanket statements that any brand of bass sucks IMHO is just a stupid jerk (again IMHO) that doesn't know how to access the proper tone from these instruments. I don't care for Fender products myself but you won't find me bad mouthing them, as obviously many people play and love them, they just are not for me.
What no one seems to have addressed here is that it will be your bass it is important that you play what you like. Find what feels, sounds, and looks good to you regardless of what is on the headstock. Regardless of what others say you should play, at the end of the day it is your bass and you have to play it day after day and night after night. If its an ESP great, if not geat ....again its your bass no theirs. If one bass fit everyone their wouldn't be literally thousands of choices out there. That said IMHO ESP basses are very good basses and are built very well. (heck I own three for a reason) for a mere $50.00 bucks more you could step up to the F-154DX which has a three band EQ, a string thru body bridge, a flame maple top, maple walnut and rosewood neck, and abalone dot fret markers.
They get the rap for being metal basses for good reason....lets run the list of players who use them shall we?
off the top of my head...
Orion from Behemoth
Tom Araya from Slayer
Pig Benis from Mushroomhead
Beefcake the mighty from Gwar
Steve DiGiorgio from Testament
Bobby Burns from Soulfly
Danny Horboychuk from Dry Kill Logic
Buske from Terror
Dave Pybus from Cradle of Filth
Laz Pina from Il Nino
Lurk from Full Blown Chaos
Fred Leclercq from Dragon Force
Aaron patrick from Bury Your dead
Henkka Blacksmith from Children of Bodom
I'm sure there are more (Probably a couple hundred more) but i didn't feel like looking them up, but you know there are plenty of Blues, Funk, Country and R & B players that use them to like:
Al Threats
Lige Curry from P Funk
Tom Barney
Warren McRae from Tina Turners Band
(again off the top of my head i'm sure there are more just don't have the time to look them up)
Don't let a few un-informed opinions or the Fender Mafia scare you off from buying or playing what you want and or like. The B.C Rch's I own are all good basses, two of them are NJ's and one is a fairly recent build all of them play and sound fantastic to my ears and hands.
But I really dig my F-404 it is my main "go to" bass and wouldn't trade it for two MIA Fenders, but that is just me.
again you have to play what you want and like. Not what others want and Like.
I Fell very comfortable in saying that the F-104 you asked about is a very good starter bass that blows away anything in its price range with it features.
I should mention I also own A Jazz Bass copy (SX), a PJ bass (i built myself) and a Stingray copy (OLP which i further modified after its original owner swapped out the pups and jack) none of these see action on stage But My ESP's and B.C. Riches often see the stage.
again play what you like and like what you play regardless of what is on the headstock
good luck on your search