I'm not very familiar with this specific light novel. It might be about a character who, through some form of reincarnation (tensei), becomes a dragon (ryuu). But without reading it, it's hard to say more precisely.
I'm not entirely sure as the title is a bit complex. 'Kawaiikereba' might imply something related to cuteness. 'Hentai demo suki ni' seems rather odd as 'hentai' has inappropriate connotations in English, but if we consider it in a more general sense perhaps it's about having a liking despite certain elements. And 'light novel' is a type of Japanese novel, often with anime - like themes.
You might try looking for it in specialized light novel stores, either physical or online. Some popular online platforms for light novels could potentially have it.
I'm not entirely sure if it's extremely popular on a global scale. However, in the realm of light novels, if it has a captivating plot about goblins being strong or having some sort of interesting power dynamic, it could be popular within the niche community of light novel enthusiasts who are into fantasy - themed stories.
I'm not entirely sure specifically what 'suki suki visual novel' is about as there could be many different visual novels with this name. It might be a story about love and relationships, as'suki' means 'like' or 'love' in Japanese. Maybe it involves the experiences and emotions of the characters in a fictional world.
I'm not entirely sure as I haven't played it specifically. But generally, a visual novel often has a story with different characters and plotlines. It might be about relationships, adventures or personal growth of the characters within the story world.