has anyone had a colposcopy/colposcopy biopsy before? how was it?

Yes, for me it was completely fine! I found the speculum the most uncomfortable part (I always do in smears anyway), I didn’t really feel them take the biopsy.