That is a very interesting question!
Because the wavefunction gives a spectrum of position values, it also gives a spectrum of momentum values, and therefore velocity values. By going at the same
average velocity as the particle, you would be in as close to the wave's own perspective as is physically possible, but my current understanding of quantum physics doesn't allow me to do better than that.
If we are moving at the same velocity as the average velocity of the particle, then its wavefunction would look like that of a particle at rest (on average). I don't have a particularly good description of this, other than the probability amplitude looking like a cloud centered around a point. More exact descriptions will vary depending on the circumstances.
Trying to visualize the oscillations of the particle on its own is a difficult task, particularly because any measurement we do only tells us about the probability rather than the probability amplitude. It is possible for the probability amplitude to oscillate while the probability itself stays constant.
That said, if we were to perform an experiment that tested something that depended on the wavelength of the particle (like how wide it diffracts after passing through a thin slit), you would be able to see that the faster the particle is moving relative to us, the shorter its wavelength becomes.
The wavefunction does change with our reference frame, yes.
The average values of the properties of a particle (position, momentum, energy, etc) mostly obey Newton's laws (see
https://en.wikipedia.org/wiki/Ehrenfest_theorem for a better description), and they certainty change depending on our reference frame.