I do play WH40K a couple of times a year. Used to play more back in the day. Still have a lot of unpainted stuff lurking somewhere.
Other board games we play on a more regular basis:
- Bang!
- Talisman
- Dominion
- Carcassonne
- Grass
Would recommend any of these if you have a group of people and haven't tried them.