I'm curious, when do you want to add a new column type? It's not a situation I've been in.
I added a column type for full text search, searching tokenized text (https://github.com/softwaredoug/searcharray)
The pandas support for extensions is very robust with extensive testing to make sure you can do all the data aggregations functionality you expect in and pandas column.