I am not 100% sure if this should be covered by a theme. I found the visual effect of the jquery tabs very attractive as shown in this website:
A perfect place to apply it is the user 'My account' page. There is a tutorial at:
Looks like not very difficult to do.