Between the issues with the sex scene and the general dislike of the ending, you might not be a Stephen King fan, but also I wouldn't write him off.

If you want to try some more King give the classic stuff a go, Carrie, Christine, Salem's Lot, that sort of stuff. Early King.

I liked Fairy Tale, but in my overall ranking I'm not sure it would land so high. I feel like in the last decade I'm just enjoying but not loving his stuff, which is also okay! But if you want to pick up a banger of more recent period King you gotta read 11/22/63.