I was working at a Lincoln dealership and had a town car in for a service. That filter was seized on. Had to use a chisel to hammer it off. Worst one I have ever seen. Only have seen 2 gaskets from the filter stay on the base, 1 I caught, 1 I didnt... Thankfully I found the issue before it had no oil.
SR20 wise, I think the worst was I had an oil filter come loose on me on a DET swap. I was using low port oil filters on the DET and thats a no on, didnt know it. It didnt happen right away either, it decided to loosen up and spin off on a second gear pull.. Not fun.