The answer depends on the ruleset being used.
In CT, with Book 2 combat and missile rules (or better yet, the special supplement missile rules) then fighters could be a real threat and could survive the combats.
In HG fighters are almost useless without adopting some house rules for linking fighters to group fire as a battery etc., and they die too easily if hit (hitting them's the problem
).
MT is similar to HG.
Fighters in TNE are very useful. They extend your sensor cover, their missiles are once again deadly and they can survive a few hits.
T4??? I've never used the ship combat system so I can't comment on this one.
GT??? Same as the above
T20 fighters become semi-useful (despite the HG based combat factors) because they can carry nuclear missiles, or fusion guns, or particle accelerators (or if the referee allows, a combination of the above), all of which can damage lightly armoured ships of whatever size. And with the critical hit rule fighters could cause a lot of damage.
I would always go for remote controlled fighters fitted with a robot brain for when the controller is jammed, or even have fully autonomous robot/drone fighters.
Why waste those highly trained and valuable pilots in death traps?
Plus you can put the space the crew would have used to much better use (more armour etc.).
The Imperium has a cultural bias against robots used like this, but other races (the Hivers and the K'kree) have adopted the concept fully.