The best piping tip for creating rosettes is typically a closed star-shaped tip, such as Wilton's 1M or 2D. These tips allow for precise control and result in beautifully defined rosettes with distinct ridges and swirls. Experimenting with different sizes can also create various effects.