The Sookie Stackhouse series by Charlaine Harris. If you don't mind YA, the Morganville vampire series by Rachel Caine. The first book is called Glass Houses.

It's a stand alone, but Sunshine by Robin McKinley is really good.  It has a really excellent, well written heroine.

You didn't mention Anne Rice.  Interview with the Vampire, The Vampire Lestat and Queen of the Damned are all great.  There are more in the Lestat series, but the first three are the best, IMHO.  Also, if you read YA try the Cirque Du Freak series by Darren Shan.  If you like humorous/romance vampire stories try Mary Janice Davidson's Queen Betsy series; light, fluffy reading, but a lot of fun.

Here are a couple of series that I recently read....The Hollows by Kim Harrison Book 1 is Dead Witch Walking....it deals with all  things supernatural and is set in the same kind of alternate reality as Hamilton without all the sex. It is really good one of my favorites. I so know what you mean there with her I have been struggling to finish book 16 but can't seem to get past chap 7 the first 4 chaps were nothing but sex and funny enough it was the same scene for 4 whole chapters.  I would also recommend the Sookie Stackhouse books to you (True Blood Series) those are exceptional books. Not so much vampire but the DarkFever Series is really good too by Karen Marie Moning. And just to add a few more check out Wings of Night series by Maggie Shyne book one is Demon's Kiss...and it you have not read the Twilight Saga it is fantastic.

Lyndsay Sands and Kerrelyn Sparks both have vamp series that are on the light side.  No chomping on the mortals!  I'd also go with Sookie Stackhouse.

Definitely Sunshine by Robin McKinley; great protagonist, great world, just be prepared to crave baked goods throughout.

Also, if you like mysteries as well, Elizabeth Bear has a collection of short stories called New Amsterdam with a vampire who is a detective in an alternate turn of the 20th century America that never broke off from England. He works in tandem with a Crown Investigator -- a woman charged with investigating murders brought about by arcane means. It's really good, and I think there's a sequel.

Definitely Sunshine by Robin McKinley; great protagonist, great world, just be prepared to crave baked goods throughout.

LOL.  I think I gained a couple of pounds while reading it.  The world is so intruguing and well thought out.  I wish she would write a sequel, but McKinley isn't making any noise about doing so.  She's such a wonderful writer.

Also - if you have a copy of Angela Carter's The Bloody Chamber sitting around, the short story "The Lady of the House of Love" is terrific, vampire-wise.

ETA - Tanya Huff's Blood series is a lot of fun.  They are mysteries that team a female Toronto PI with Henry Fitzroy, the illegitimate vampire son of Henry VIII.

Sunshine by Robin McKinley.  And Sookie Stackhouse.  And I enjoyed the Queen Betsy series as they are pure humor (the smartass kind).

I haven't read this yet but I just picked up a book called A Rush of Wings by Adrian Phoenix.  I'm not big on vampire romances and I got this mainly for  game.  But I think Im' going to read it first.  So I can't say if it's good or not.