How rare is my r reg Renault megane 2.0 litre 16 valve convertible?

Not rare. There are 82 for sale on Autotrader, there will be more than 100 on eBay and likely many more in dealerships and auctions. They were popular.