I have it: a tenure-track professor at a small liberal arts college. It's mostly teaching, but without an insane teaching load, decent support for research, but relatively low research expectations. So basically, I teach a few courses, do a little research (really as much as I want), do a little service (committee work, etc), and feel like I can do it well while still having a ton of autonomy and free time.
Only down-side: I have a few bat-shit crazy colleagues. So, I guess maybe I should change my answer to: my ideal would be same job I have with a few colleagues retired and with officially having tenure (shouldn't be a problem to get, but won't be ideal until 100% secure). Or maybe I can get the same effect as the crazies retiring mentally by continuing to work on ignoring them and not letting them bother me.