As trail rat said. Forget ‘what shoe is best for x terrain’ or ‘what brand is best value’. Go to a proper runner’s shop, get properly fitted with a shoe which fits your feet and gait and go with that.
Thats all well and good for road running, but the OP specifically asked for 50/50 road/trail shoes and unless they let you run off road to test them, then no amount of running around a carpark is going to give him a good analog for trail running.
All that gait analysis stuff they do is mostly a gimmick designed to sell you some shoes.
just buy a pair online, try them on. if you feel they are comfortable enough go for a run as no amount of trying different pairs of shoes in a shop will translate to real-life.