I get it occasionally. Most common and unhelpful time is levelling out after the base turn on a procedural approach - just when I'm trying to correct to the centreline and look out for the FAF. Happened at Gloucester last week.
Never had serious vertigo, though - that sounds extremely unpleasant.