Generally, the big expensive ones are for people very deep into the hobby, while "family fun" type stuff will be a lot cheaper. Not all of the expensive ones are like you described, but almost all of them are overly complex or gimmicky for anyone who isn't a heavy consumer of the medium.
Some reccs, based on what I've played and where we are:
Simple/Affordable:
Pandemic, Catan, most card/deck based games
Simple/Pricey (usually due to having tons of very nice figurines):
Cthulhu Wars, Talisman, Bloodbowl
Complex/Affordable:
Aliens: Another Glorious Day in the Corps, Dungeon Saga, Warhammer: Underworlds
Complex/Pricey (but pretty great if you get into it):
DooM, Twilight Imperium, Necromunda