Great in sex, tremendous! (7)
I believe the answer is:
extreme
'great' is the definition.
(synonyms)
'in sex tremendous' is the wordplay.
'in' indicates the answer is hidden within the clue.
'EXTREME' is hidden within 'sex tremendous'.
(Other definitions for extreme that I've seen before include "lacking moderation" , "not least" , "Draconian" , "Going beyond moderation" , "not near the centre" .)