Actually I want to recommend another Frank Herburt novel, but not from the Dune series: The Santaroga barrier. It's essentially a psychological scifi about a psychiatrist entering this town where every one seems to have a altered consciousness. It is a bit older, what with 1960s mindset going on, bit it's interesting reading what is essentially a contemporary scifi instead of a futuristic one.
Ah, what else can I recommend... Yokohama Station SF was fantastic, really atmospheric piece.
Oh, and I can't forget my all time favorite: Robot's have no Tails, by Henry Kuttner. Basically it's about this amoral mad scientist named Gallagher who is only a genius when he's drunk, and then he sobers up and has to deal with his drunken mad science rampage. I especially liked the story about him dealing with a time machine that drops his corpse off at his doorstep, only to rematerialize a younger version of him who is dead every hour or so. The entire section about him dealing with a hangover, while trying to figure out a legal defense for the cops due to them picking up his own corpses filing up the mourge was amazing. That scene lives rent free in my mind till the end of time.