In 2 Samuel 11, we find the story of David pursuing pleasure in an illicit relationship with Bethsheba. David sins and then commits further sin to cover his original sin. The chapter ends with this summary: "But the thing David had done displeased the LORD." (vs. 27). No matter how much pleasure I may receive from sin, it always displeases the LORD.
The ultimate question is, "Whose pleasure is more important, mine or God's?" Ironically, God desires my pleasure, and He offers it through an eternal relationship with Him through His Son Jesus Christ. His pleasure is that I might find my eternal pleasure in Him. And I can only find it in Him alone. David later wrote, "You have made known to me the path of life; you will fill me with joy in your presence, with eternal pleasures at your right hand." (Psalm 16:11).