I believe #pubky are working on rotation as a first-class use case. Some good bits and some bad bits in NIP-41. I favour #subkeys right now. Let's see how it develops, though.
Agreed subkeys are another good solution.