New insight into tuning magnetic phases of RMn6Sn6 kagome metals