The book has sold millions of copies and was the inspiration for the three films. That alone speaks volumes of how successful the novel really is.
But without francis ford coppala the movies would not have been that great, he was the backbone of the movies not puzo in my opnion.
The book was average and sold many copies as you said, it doesnt mean its a great book.