Boring person, dull, lame, dreary, a person who ruins a good mood.
His wife was a bit of a wet fish at the orgy, she only gave me a handjob.