The correct preposition to use after 'better' in this context is 'as'. When comparing roles or functions, 'as' is used. For example, 'He works better as a manager than as a clerk.' Therefore, the sentence should read 'He was both a writer and a politician, but he was better as a singer.'