Analog curved spacetimes in the reversed dissipation regime of cavity optomechanics