CRA has curated a growing set of undergraduate research highlight videos that portray this diversity of experiences and goals. You can use them and conversations with other undergraduates to help get a sense of just how different experiences can be, depending on who you collaborate with and what questions you’re trying to answer in research.
You can also review the research highlights on the site, which provide many examples of undergraduate research projects.