Newport has been named as the worst place to visit for a staycation according to new research, with two other Welsh destinations also scoring poorly